CODEWITHSUNDEEP
sqlsql-serveroracle-databasetriggerslinked-server
Tahere
Tahere

Reputation: 15

How to find different data in SQL Server table and equivalent table in Oracle?

There is a SQL Server tables which has equivalent tables in Oracle. They connect via a linked server and when a new record is inserted ,updated or deleted into/from SQL Server tables, the Oracle tables will be updated using different triggers.

If SQL Server triggers were disabled the Oracle tables would not updated as well. Thus different data rows are generated in SQL Server and Oracle.

How can we find these different data? Is this any way to check if triggers are enabled or not?

Upvotes: 1

Views: 57

Answers (1)

Littlefoot
Littlefoot

Reputation: 142720

What's in "A" and not in "B" can be found using the MINUS set operator. For example, if there's a common ID column in both tables, you'd

select id from ms_sql_server_table
minus
select id from oracle_table

Apply the "linked server" syntax to it; in Oracle, that would be a database link, I presume.

I don't know how to check whether triggers are enabled in MS SQL Server; I don't use that database.

Upvotes: 1

Related Questions