Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 28th, 2004, 01:29 PM
Registered User
Join Date: Dec 2004
Location: Amman, , Jordan.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Synchronizing 2 tables on 2 different data sources


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

Reply With Quote
  #2 (permalink)  
Old January 6th, 2005, 11:32 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts

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.
Reply With Quote
  #3 (permalink)  
Old January 29th, 2005, 08:55 AM
Friend of Wrox
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Oct 2004
Location: New Delhi, India.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar

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
Reply With Quote
  #4 (permalink)  
Old February 24th, 2005, 01:37 AM
Authorized User
Join Date: Apr 2004
Location: Gurgaon, Haryana, India.
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ranakdinesh

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
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: IListSource not contain any data sources. cJeffreywang ASP.NET 2.0 Basics 1 October 17th, 2007 03:04 PM
Joining data from multiple data sources ClaesR BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 August 28th, 2006 09:30 AM
Enumerate SQL data sources RFickling C# 0 May 22nd, 2005 10:49 AM
Query from multiple data sources billmedd BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 September 27th, 2004 10:46 AM

All times are GMT -4. The time now is 04:44 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.