December 6, 2012 at 3:35 am
Hi,
I have a question... I have a migrate data of a dataase to another database. I have written sql queries (Insert into table1 .....select columns from table2) in this manner. How can i ensure that data that I have migrated is correct?
Is there any tool available for this so that I can check that data that I have migrate is accurate.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 6, 2012 at 5:22 am
Hello Kapil,
Does the destination database have any existing data? If not, why not use backup-restore?
If the destination database already has some data and you are copying data from existing tables from old database to new tables in the destination database then, have a look at tablediff.exe.
If the destination table also contains some data then, you probably have to migrate data in a transaction batch and compare manually before committing the transaction.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply