Hi
Can someone please tell me, when i setup a publication for
transaction replication (push only), sometimes it says:
"SQL Server requires that all articles in a publication
allowing updatable subscriptions contain a
uniqueidentifier column named 'MSrepl_tran_version' used
for tracking changes to the replicated data. SQL Server
will add such a column to published tables that do not
have one"
But other times it does not ask to do this, and i have
successfully had a replication running without the
requirements is says. Do i need it or not?
Hi
If you want the changes to be replicated from the subscriber to publisher,
using immediate updating or queed updating, it becomes a requirement that
uniqueidentifier column is needed. If you dont want the reverse update, then
you may not need that column. Hope it helps
shrini
"gravity" <anonymous@.discussions.microsoft.com> wrote in message
news:1be901c42700$200f1880$a301280a@.phx.gbl...
> Hi
> Can someone please tell me, when i setup a publication for
> transaction replication (push only), sometimes it says:
> "SQL Server requires that all articles in a publication
> allowing updatable subscriptions contain a
> uniqueidentifier column named 'MSrepl_tran_version' used
> for tracking changes to the replicated data. SQL Server
> will add such a column to published tables that do not
> have one"
>
> But other times it does not ask to do this, and i have
> successfully had a replication running without the
> requirements is says. Do i need it or not?
Monday, March 26, 2012
MSrepl_tran_version - needed or not?
Labels:
database,
fortransaction,
hican,
microsoft,
msrepl_tran_version,
mysql,
oracle,
publication,
push,
replication,
requires,
server,
setup,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment