How Do I Sync 2 Table Of Databases

Question

0.00/5 (No votes)

See more:

Hi I have 2 database in 2 servers but same in tables

inserting in table1 in database A (cloud server with static IP) with my website and inserting table2 in DB B (in local server without static IP) with my local application
now i need to write some code to sync those when in click sysn button in my local c# application

sync description:

DB_A.table1 With DB_B.table1
AND
DB_A.table2 With DB_B.table2

(Get from A.tb1 and insert in to B.tb1 and Get from B.table2 and insert in A.tb1 )

please help me how can i do that?

regards

Posted 25-Apr-15 2:09am

Roozbeh Amiressami

Add a Solution

1 solution

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)

Aydin Homay · Answer 1 · 2015-04-25T03:32:00

Hi
To do be honest for doing this work you have a lot solutions just try to goggling you will find amazing solutions like making mirror database, Ip forwarding or using web service (of course I like it this idea ;-) ) and I have a other solution for you that is Self-Synchronized Data Access Layer[^] in this article with small change you create self-Sychn mechanism for your application, just let me know if you need more information.

Other useful Links:
https://msdn.microsoft.com/en-us/sync/bb887608.aspx[^]
http://social.technet.microsoft.com/wiki/contents/articles/4654.sql-server-replication-technologies.aspx[^]
http://www.symmetricds.org/[^]
https://en.wikipedia.org/wiki/Microsoft_Sync_Framework[^]