none
Data Comparison between SQL Server 2000 and DB2 RRS feed

  • Question

  • Hi,

     

    I have to compare a table available in the sql server 2000 and the DB2 database. Volume of data is huge. It has nearly 500,000 of data.

     

    I have created a prototype to get the tables from each db into a dataset and convert the datasets into XML files of each database.

     

    Then i have used XMLDiffView to compare the data between these to tables. The size of each file is nearly 550 MB and when i had run the XMLDiffView it was taking very long time to compare.

     

    Please let me know whether it is a feasible solution or is there any other good approach that i can follow to perform the same task. 

     

    Example:

    I have a table called test1 in sql server and test2 in DB2. I have to compare these two tables (test1 and test2) and get the differences.

     

    Thanks in Advance,

    Malar

     

    Thursday, February 21, 2008 7:21 PM