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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

puppydogbuddyCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vadim RappCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.