Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# SQL SQL-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 6:09am
Edited 27-Nov-12 9: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 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 OriginalGriff 120
3 PIEBALDconsult 110
4 Zoltán Zörgő 99
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100