Click here to Skip to main content
15,301,414 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need some help,

I have 2 SQL server database ( for 2 different application) running on 2 different machine in same domain. Say A and B.

A has some 25 tables and B has some 15 Tables. in that i want to some table information ( say EMP Details) from Table B to be synchronized with Table A

Database A Database B
Table EMP Table EMP_information
EMP.FirstName FirstName

To achieve this task, what is the best approach?

1. Microsoft Sync Framework
3. Writing a module which will keep tracks of Database A transaction (update,insert and delete) and accordingly send the information(CHANGES) to the Database B (using queries)
4. Trigger or some other stuff.

Please kindly help me out with good reference. Thank you.
Updated 27-Nov-12 8:07am
Amaan23 26-Nov-12 12:50pm
42 views and no reply :(
Please help me
Amaan23 27-Nov-12 13:52pm
any more suggestions please

Amaan23 26-Nov-12 14:14pm
thanks Jitendra,

Both links are same and i have ready gone through this link. Thank you.

any more suggestion
Jitendra2005 27-Nov-12 0:00am
corrected the link...thanks
Take a look at SymmetricDS.

1) SymmetricDS works with SQL Server.
2) Supports mapping records from table A to table B.
3) Comes in open source or professional versions.

Open Source:

4) Uses triggers, and some other stuff.

There is a free 30 day SymmetricDS Pro demo at

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900