Saturday, February 11, 2012

@update_mode for Bidirectional Transactional Replication

Hi
I'm in the process of working out how we are going to set up
replication for a client. Quite a daunting task.
I'm think we are going to use Bidirectional Transactional Replication,
as described here:
http://support.microsoft.com/default.aspx?scid=820675
If you look at the sample you will see that they use @.update_mode =
N'sync tran' when creating the subscription. Is this necessary? I set
it up using @.update_mode = N'read only', which seemed to work fine, but
I am worried that I might be missing something.
Any comments welcome...
Thanks
Gary
that's a doc bug - it should read readonly.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Gary van der Merwe" <garyvdm@.gmail.com> wrote in message
news:1130327855.663530.282590@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm in the process of working out how we are going to set up
> replication for a client. Quite a daunting task.
> I'm think we are going to use Bidirectional Transactional Replication,
> as described here:
> http://support.microsoft.com/default.aspx?scid=820675
> If you look at the sample you will see that they use @.update_mode =
> N'sync tran' when creating the subscription. Is this necessary? I set
> it up using @.update_mode = N'read only', which seemed to work fine, but
> I am worried that I might be missing something.
> Any comments welcome...
> Thanks
> Gary
>

No comments:

Post a Comment