November 28, 2001 at 7:13 am
I really only have 5 days knowledge on replication but my question is 2 fold:
1. What does the 'ExchangeType' setting of the merge object do, as it evidently does not set merge replication to only work in one direction (e.g. to do merge only from the subscriber to the publisher, and not back)
2. With trans repl, the wizard and scripts automatically add a field named 'msrepl_tran_version' by dropping and recreating the table (if you select not to drop the table and only delete the content, the replication breaks stating invalid table, because it ain't there). Is there a way to add this column without dropping the table first, offcourse without me adding the column myself, or writing my own script. (There is already data in the tables.)
Thanx
japieson
November 28, 2001 at 2:41 pm
I'd have to check on merge, rarely use it. For transactional I think you only need to add the column if you're doing updating subscribers. In SQL2K you can add columns without a lot of work via the replication wizard. I've got a couple articles posted here on the site that go into a little detail.
Andy
December 10, 2001 at 9:02 am
There are three different ways you can use merge replication by using the ExchangeType
Property the default is merging changes from both subscriber and publisher which is ExchangeType -3.
You can only replicate data in one direction i.e from publisher to subsciber or Subscriber to Publisher u have to set the exchange type at the merge agent.
ExchangeType 1 from Subscriber to publisher
ExchangeType 2 From Publisher to Subscriber
ExchangeType 3 (Bidirectional)* Default
Aleem A Mohammed
Aleem A Mohammed
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply