Synchronization between 2 database in different server in sql

I want to make a synchronization between two table of same structure.The 2 databases are
in different server.
   Is it possible for 2 way synchronization.?
helpme2013Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
for single table you can create SSIS package and in that use dataflow task.


In that, you can use Source Table and Destination TAble
->
Merge both on some key column.
-> Check those key columns for value.

If Key column value is null for Destination table then insert row to destination.
else update destination table.

To do that you can use the split task.
0
 
BAKADYCommented:
0
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
ZberteocCommented:
You can use merge replication between the 2 databases with that table as an article:

http://vimeo.com/2629246
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.