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 :)