Comparing data in 2 tables of 2 different datasets and updating to the database

Jan 22 2005 8:16 AM
Hi All This is Srinu!! I have 2 datasets say DS1 and DS2. DS1 holds a table called Prodcut_Master from LIVE server and DS2 holds a table called Product_Master from WEB server. So i want to update all the changes made in the live server during a period to the web server. DS1 may have data of 2 days old.. DS2 may have the same data from the web but there may be some data which has inserted/modified/deleted in LIVE server (DS1) so i want to update the same in WEB server (DS2 ) and finally to the Database. hope the question is clear. Thanks for your REPLY. Srinu