Database comparision Tool

can't think of one at present, but its success would depend on  the nature of the transformation you had applied to the data, data structures, functions etc... what did you use to perform the migration? wouldn't that have in built audit trails?

a standard approach would be to count the rows,sum values,count references on the tables before and after and confirm that they match...

then also to run some random and standard user access requests to confirm that result are the same/within tolerance...


also at what level are you wanting to perform the comparison just table/data or views, procedures, users, etc

I don't think there's such a tool that can compare databases record by record. Even for schema I think there are only tools for comparing databases from same DBMS.
I suggest you to script both datbases schemas and compare with a text compare tool. After you should create a script to count records in each table of each database and after compare those values.

Good luck

If you have MS-Access, you could attach the tables from both Oracle and SQL Server and then run three queries per table to check for differences.

1. left join on table key (where right key value is Null)
2. right join on table key (where left key value is Null)
3. inner join on table key (where any of the fields are not equal)

I realize that this won't be very modest, but it seems to me that only my comment has actually recommended the tools the question was about.