Hi,

I need to synchronize 2 different tables that exist on 2 different data sources using the most fast and optimized way possible using ADO.Net because this has to be stored as a scheduled job that will run regularly.

Here is the scenario:

I have a table named:
Books (BookID Integer-PK, BookName Char(40), LastUpdate DateTime )

This table exists on a MS Access database. Every so often I have to run a scheduled job that opens a connection to this MS Access database, reads any changes, additions or deleted rows that have occured in this table and that are different than the cloned table that exists on a SQL Server 2000 database. The LastUpdate timestamp column will be used for this comparison purpose. So that any new rows, deleted rows or changed rows have to be updated accordingly to the table that exists on SQL Server 2000.

The critical thing is that this has to be done using the most efficient and optimized way possible using ADO.Net.
Note: I am using VB.Net as a programming language and OLEDB as the data provider.

Thanks in advance

- Luai :)

Unless you have a particular need to do this is .NET, this kind of task can usually be accomplished by creating a Data Transformation Services (DTS) package in MSSQL. It can support what you are looking for and be scheduled.

hi to all

i have the similar problem and the DTS Package is the obvious way.But i can't use it because the my second database is on the clients website under the control of respective ISP. I am formulating the solution through ASP.Net Web Services which will use XMl files to update the online database from the offline database. The question not actually lies whether you are using homogenous or hetrogeneous data sources. It is the way how the two data sources are to be synchronized.

For all those who refer to Wrox Profeesional VB.Net book, the chapter about web services in the book talks about the same problem.

Anubhav Kumar

I Alos Have the Same Problem In My Case My Website is Running on Sql Server. My Satff members located in almost all parts of Country need data in Access Format to Print Certain Reports. and we can't provide Dts Facility to Every one in some Cases there is no presistent net Connectivity.So I am using a long procedure with with Lots of Bugs to do So.

dinesh Rana