Click here to Skip to main content
Rate this: bad
good
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
EMP.LAstNAME LastName
 
To achieve this task, what is the best approach?
 
1. Microsoft Sync Framework
2. SQL (SSIS)
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
Amaan23424
Edited 27-Nov-12 9:07am
v2
Comments
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
good
Please Sign up or sign in to vote.

Solution 1

I think in this following would be good:
 
1. SSIS.
Reference:
http://blogs.msdn.com/b/jorgepc/archive/2010/12/07/synchronize-two-tables-using-sql-server-integration-services-ssis-part-i-of-ii.aspx[^]
 
2. Database Merge Replication.
Reference:
SQL Server 2005 - Merge Replication Step by Step Procedure[^]
 
Thanks,
Jitendra
  Permalink  
v2
Comments
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
good
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: SymmetricDS.org
Professional JumpMind.com
 
4) Uses triggers, and some other stuff.

There is a free 30 day SymmetricDS Pro demo at JumpMind.com.
  Permalink  

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



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.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