Toad World® Forums

Data Compare


#1

I would like to compare table data between ms Access and oracle. Does this feature work between Ms Access and Oracle

Data was exported from access then imported into oracle. I tried using the data compare and sync function from the tool menu.

The data compare wizard opens, when I try to define my source I click on the icon to create a new connection (only db listed in the Alias drop down are my oracle database.)

I entered in the requested information, pick a group, ms access , select access .mdb file, click connect,

new connection window automatically closes, there is no information in source side of the wizard.


#2

Unfortunately, we currently do not support Access databases in Data Compare.