Compare SQL Server and Oracle databases

1123980 pts.
Tags:
Database
Oracle
SQL Server
Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we can see if any data is missing on a day-to-day basis. How can we do that? Should we use SSIS? Thank you for your help.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Here is a link to an Oracle web page that has your information.

https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_diverge.htm

Hopefully the SQL table is always the receiver and never updated by any other functions. You can only have one version of the truth and that seems to be the Oracle version. That being said, you need to setup a trigger on the Oracle table so changes are sent over to SQL automatically.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: