May 2, 2012 at 10:01 am
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
May 2, 2012 at 12:02 pm
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
May 2, 2012 at 12:04 pm
Didn't read closely enough. You are using SQL 2000 - no EXCEPT operator. I'd use UNION. 🙂
_________________________________
seth delconte
http://sqlkeys.com
May 2, 2012 at 8:05 pm
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
November 14, 2019 at 7:13 pm
How do we create a linked server? Are there any other ways of doing this?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply