Post reply

Database Migration

  • December 6, 2012 at 3:35 am

    #267797

    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

    #1566107

    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