Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : Transactional Replication


Roger Nygård
1/19/2006 11:15:47 AM
Mssql 2005 - Mssql2000

I try to create a "Transactional publication with updatable subscriptions:"
But I can see that all tables cet an added colunm "msrepl_tran_version"

Is it possible to replicate 2-way that wil not add this column
(msrepl_tran_version)?

What will happen if I set up "Transactional publication" in both Database.
ie. both is a Publisher and Subscriber at a same time?

The data that will be updated and inserted will newer confilct in our
environment. (The Software we use manage this.)

Roger Nygård
Ask IT

Hilary Cotter
1/19/2006 2:01:40 PM
Please refer to http://www.indexserverfaq.com/bidireproscript.sql or
http://www.indexserverfaq.com/Mike1.sql for examples of how to set this up
without the extra column.
--
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

[quoted text, click to view]

AddThis Social Bookmark Button