Friday, March 9, 2012

replication - synchronisation

Hello,
I have to do a task, but I'm newbie in sql server replication, so I ask
you what I have to do in this case:
I have two SQL Servers A and B. What I have to do, is to synchronise some
tables from these databases.
So when I modify a table in srvA, to update in srvB and vice-versa when I
modify the same table in srvA to update in srvB.
So, a double side synchronisation.
can somebody tell me the bases of this task to know what I have to handle in
the future.
Thank you a lot
Alex
The easiest way to set it up would be merge replication. If you are
concerned about performance then bidirectional transactional replication
would be a better alternative, although you'll have to write your own
conflict routines in the transactional stored procs for this.
As you are a replication newbie, I'd recommend you to do loads of reading in
BOL, set up loads of test scenarios, even if it is on one box, get hold of
Hilary's book and have a look at the past messages on this discussion group
to see the likely obstacles, gotyas etc.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment