Syncronise updated Data using C#.Net

Question

0.00/5 (No votes)

See more:

Hi All,

I want to syncronise data from different Tables on periodic basis from one database to other. I want only to find the new updations made in one database and want to reflect to other respective database.
I dont know the tables in which the records are updated.

For eg. If I add a record in table X, its respective transation is affected in Table B of Database C.

All the database will be on differnet servers/Locations eg - Main Server is A and I want the updations from Database c,d,e which can be in different location.

Please Help.

Regards,

Chirag.

Posted 20-Feb-12 22:00pm

Chirag Shah.Gogari

Updated 20-Feb-12 23:46pm

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pietvredeveld · Answer 1 · 2012-02-20T22:21:00

Solution 1

You could for example read both the databases and compare the result sets to find the changed rows. These rows you have to update...

you can use a timer for doing this periodically.

Probably not the best solution but this should do the it.

Regards
Piet

Posted 20-Feb-12 22:21pm

pietvredeveld

Comments

Chirag Shah.Gogari 21-Feb-12 4:40am

Hi, Thanks for your responce, But the issue is that I dont know the tables in which the records are updated and eg, If I add a record in table X, its respective transation is affected in Table B. Abd both the database will be on differnet servers eg - Main Server is A and I want the updated from Database c,d,e which can be in different location

ProEnggSoft · Answer 2 · 2012-02-20T22:21:00

Solution 2

Put a time stamp field in the first database. In the second database store the previous update time. Then periodically when you want to update the second database, select all the records in the first database which are newer than the previous update time stored in the second database and update the previous updated time in the second database to the present time for further updates.

Posted 20-Feb-12 22:21pm

ProEnggSoft

Comments

Chirag Shah.Gogari 21-Feb-12 4:35am

Hi, Thanks for your responce, But the issue is that I dont know the tables in which the records are updated and eg, If I add a record in table X, its respective transation is affected in Table B. Abd both the database will be on differnet servers eg - Main Server is A and I want the updated from Database c,d,e which can be in different location

**AmitGajjar** · Answer 3 · 2012-02-21T00:14:00

Solution 3

Hi,

You can use Microsoft Synchronize Framework.

This will synchronize your databases with different scenario.

hope this will help you,

thanks
-Amit.

Posted 21-Feb-12 0:14am

AmitGajjar