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)

  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