Database comparision Tool

Hi.

Can anybody suggest me some database comparision tool.
We have a database migrated from oracle to sqlserver 2008
We need to make sure we have migrated all the data into the sqlserver 2008.
There are several tables with 50million rows.
So we need to have the best performance also.
VarshiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
puppydogbuddyConnect With a Mentor Commented:
I would check out the free migration toolset from Microsoft:
                    http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx

Also check out these how to articles on Oracle to SQL server migration:
                   http://www.sql-server-performance.com/articles/dba/migrating_from_oracle_to_sql_server_p1.aspx

                   http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx
0
 
LowfatspreadCommented:
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

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
aikimarkCommented:
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)
0
 
Vadim RappConnect With a Mentor Commented:
Wikipedia has an article about this, with the table of features in different products.

http://en.wikipedia.org/wiki/Comparison_of_database_tools
0
 
Vadim RappCommented:
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.
0
All Courses

From novice to tech pro — start learning today.