Click here to Skip to main content
11,647,170 members (70,180 online)
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 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

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 510
1 OriginalGriff 352
2 DamithSL 310
3 Sergey Alexandrovich Kryukov 305
4 F-ES Sitecore 244
0 OriginalGriff 1,277
1 994
2 DamithSL 946
3 Sergey Alexandrovich Kryukov 853
4 CPallini 760

Advertise | Privacy | Mobile
Web04 | 2.8.150804.2 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2015
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