Compare tables in SQL Server and Oracle

Question

I have a set of SQL scripts for moving data from tables in SQL Server 2005 to Oracle 11. I want to compare data in two databases to make sure that they migrate correctly.

My source: SQL Server 2005. It has 10 large tables with approximately 80 million rows and 20 tables with approximately 100,000 rows.

My goal: Oracle 11 on Exadata, which has a similar table structure for its source.

Any idea what I can do? Are any tools available?

Answer 1

Perhaps you can create a function that will be for each column in each table:

• combine row number with value
• hash it (md5 should be available on both)
• XOR -.

, , , , .

: , , . , 1000 , .

Answer 2

SSMO Oracle. , except

select * from table1
except
select * from [link_server]..myschema.TABLE1
union
select * from [link_server]..myschema.TABLE1
except
select * from table1

. , oracle CLOB.

: sql- , DBA. , .

Answer 3

, , , : " unit test ETL , , , ?"

, , .

. , , . ​​ # Java , .

. ETL , , , .

, .

: .