SQL Server Performance Forum – Threads Archive

Replication Question

All,
I trying to set up replication (one way transactional) from one 2000 instance to another. We have many text fields that we would like to replicate. I have been reading about planning for replication and read the following on technet:
INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are supported with no special considerations. However, these columns cannot be updated by Subscribers that use snapshot replication or transactional replication and immediate updating or queued updating subscriptions.
We don’t want to have the subscribers perform any updates…what does the "without consideration mean" does that mean that we do not have to use writetext?
Peace, Joe O’Brien

You can use writetext as long as you are not using with NO_LOG option. Because transactional replication uses the transaction log for replication and with NO_LOG does not write to transaction log.

I know I CAN use writetext. The question is do I HAVE to use writetext…
Thanks, Joe O’Brien

Hi Joe, No, you won’t have to use writetext. I replicate text columns without any issues <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> Cheers Twan

May take reference of this MSDNhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replplan_1l4e.asp article and you should also make sure that you do all text ptr operations within a transaction on the publisher. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Satya,
The link you provided was where I got the reference. INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are supported with no special considerations. However, these columns cannot be updated by Subscribers that use snapshot replication or transactional replication and immediate updating or queued updating subscriptions. I was trying to undertand the phrase.."INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are supported with no special considerations." OK call me paranoid – I just wanted to make sure it is as the note read. Thanks for the input. Joe O’Brien

Yes. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>