Post reply

Data validation options after data migration from Sybase to Sql Server

  • June 24, 2014 at 2:56 am

    #308481

    Hi All,

    I am currently in the process of migrating data from Sybase to Sql server and would like to know how to test the data migrated.

    As of now, we took one table data from both source and destination and compared it in Excel to check if the data migrated looks good (note, we used SSIS to migrate data). However, I would like to check if there are any other best & easy ways to apprach data validation post migration.

    Thanks.

    Regards,
    Suresh Arumugam

  • June 24, 2014 at 4:21 am

    #1724269

    It depends on how critical it is to verify data and what is the size of the data? Simply you can run the query to all user database to select count(*) to verify the no. of records.

    If you need to verify further you can create the linked server for SYBASE and verify data between SYBASE and SQL record by record in each table using T-SQL.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • June 24, 2014 at 1:23 pm

    #1724450

    Thanks for your suggestions.

    I would like to try out the linked server option and have queries to do some comparison of tables. Could you please share any ideas on how the data validation linked server query logic should look like as I have 104 tables to be tested for validations?

    Thanks in advance.

    Regards,
    Suresh Arumugam

  • June 26, 2014 at 11:01 pm

    #1725331

    Hi All,

    Please help me with your suggestions for my above request to find a best way to do data migration.

    Is Checksum helpful to validata data?

    Thanks in advance.

    Regards,
    Suresh Arumugam

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

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