Post reply

Testing the data after migrating to a new storage

  • September 24, 2009 at 9:26 am

    #385426

    Hi All,

    I have a testing requirment to ensure the data is moved without any miss out after migrating the database from one storage to another storage.

    We have come up with some suggestions like ensuring the number of records in all the tables before and after migration. However its not giving the confident on the data table columns.We can not check the each and every fieds for this requirment.

    Please post if you have any best practice or experience on that.Correct me if my question does not make any sense.

    Regards,

    Arafath.

  • September 24, 2009 at 11:54 am

    #1058180

    You may use the tablediff utility to compare tables .

    http://msdn.microsoft.com/en-us/library/ms162843.aspx

  • September 24, 2009 at 12:09 pm

    #1058190

    Thanks vky3...I am expectiong things for other database objects also...

    And another one thing is comparing each and every object is very difficult...

    Anyway thanks for your help...

    Regards,

    Arafath.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply