SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

arorasaurabh82
Starting Member

India
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.

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 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

arorasaurabh82
Starting Member

India
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000