Groups | Blog | Home
all groups > sql server replication > september 2005 >

sql server replication : Which Replication


Paul Ibison
9/13/2005 12:00:00 AM
John,
I'd use transactional for this scenario.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

John
9/13/2005 8:05:03 AM
hi i moved one of my test database to another testing dep server. what ever
the chnages happen in Publisher database, it need to sync subscriber database
at a particular time. so i have choosen Snapshot Replication.
i want only updatabale data should move to subsciber database on nightly
basis.
is snapshot is best or transactional or merge?

please advice.

Thanks,

AddThis Social Bookmark Button