CODEWITHSUNDEEP
sql-serversql-server-2008cluster-computing
EK.
EK.

Reputation: 2996

SQL Server tables replication

Is it possible to replicate 2 SQL Servers on table level? (I want to replicate only few tables, not all DB). Both SQL Servers work on different physical servers and should synchronize a few tables.

If it is possible, how to avoid conflicts?

Thanks!

Upvotes: 0

Views: 781

Answers (1)

AnandPhadke
AnandPhadke

Reputation: 13506

Yes you can use MERGE Replication provided both source and destination table names should be same.I guess transactional replication might support if table names are different.

Upvotes: 1

Related Questions