comparing access and Oracle rows
I have 2 seperate databases and I need to check for rows that are different from each other in a table. One database is running on SQL Server and the other on Oracle.
I used access to link the tables in a database and am using queries to check the tables. I used joins to make such a comparison and it seems to work fine. However, I am having a few problems.
When I try to compare entries that are null, it always shows that the records are different. It seems that SQL Server and Oracle handle null values seperately. Is there any way to compare these null values properly in Access?
How can I compare BLOB and Memo fields of the databases. Access would not let me compare entries that have these datatypes.
Any help would be appreciated.