Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#SQLSQL-Server
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.
Posted 26-Nov-12 5:09am
Edited 27-Nov-12 8:07am
Amaan23 at 26-Nov-12 12:50pm
42 views and no reply :(
Please help me
Amaan23 at 27-Nov-12 13:52pm
any more suggestions please
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I think in this following would be good:
1. SSIS.
2. Database Merge Replication.
SQL Server 2005 - Merge Replication Step by Step Procedure[^]
Amaan23 at 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 at 27-Nov-12 0:00am
corrected the link...thanks
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 718
1 OriginalGriff 421
2 Tadit Dash 355
3 sanket saxena 329
4 Peter Leow 193
0 Sergey Alexandrovich Kryukov 12,109
1 OriginalGriff 7,326
2 Peter Leow 5,003
3 Abhinav S 4,003
4 Maciej Los 3,575

Advertise | Privacy | Mobile
Web01 | 2.8.140421.2 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid