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. 



    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,



    Thursday, February 21, 2008 7:21 PM