Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 MySQL database verification
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

4 Posts

Posted - 04/20/2014 :  08:14:42  Show Profile  Reply with Quote
HI I am new to database, in one of project MS-SQL database has been migrated to MySQL and i have been assigned job to verify the integrity of the database after migration. I am not aware of database as it is not my cup of cofee, but forced to drink it. Need expert advise in how to verify the data was migrated properly or not.

Flowing Fount of Yak Knowledge

United Kingdom
3385 Posts

Posted - 04/20/2014 :  09:27:46  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
You need to compare the data in sql server to that in mysql.
Probably they do not have the same data representation which will have been taken care of in transforming te data for migration.
There wlil be two parts - verifying that the those transformations end up with a viable representation of the data for the business needs and to verify that the migration hs been carried out correctly and completely.

Have the tables just been coppied across using the same structures?
If so then the first step should be ri compare the row counts from the tables.
If the structures are not the same then you need to look at counts of business entities.

Then you need to reconcile the detailed data which means comparing the data in the two systems. You can do this by an extract from the two systems and a compare or you could take a random sample from each table and compare those with the other system

Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Starting Member

4 Posts

Posted - 04/25/2014 :  00:57:35  Show Profile  Reply with Quote
Thanks for the response, do we have any open source tools or scipts available which can do this comparison. I am looking for more automation opportunities rather going for manual process.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000