Best way to compare data/tables between SQL and Oracle
-
Hi
I have to do a data compare. Currently, we are running two databases in parallel. 1 database is in sql server 2000 and the other is in Oracle 11g. I have to compare 15 tables sql against the same 15 tables in Oracle.
I need to compare the data content of the fields. what is the best way or tool to accomplish this.
this is for a small audit to ensure that our ETL process is in sync.
thanks in advance
-
I'd create a linked server from SQL Server to the Oracle server, then compare database tables using EXCEPT or UNION.
_________________________________
seth delconte
http://sqlkeys.com -
Didn't read closely enough. You are using SQL 2000 - no EXCEPT operator. I'd use UNION.
_________________________________
seth delconte
http://sqlkeys.com -
How much data are we talking total across the 15 tables?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato -
How do we create a linked server? Are there any other ways of doing this?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply