March 1, 2004 at 2:26 pm
Does SQL 2000 transaction-based replication still use add/delete pairs the way previous versions did? (Sorry for the dumb question. I supported 6.5 replication for ~4 years, but hadn't yet worked with that part of 2000. )
esc
March 1, 2004 at 3:58 pm
Don't know about pre-7 versions, but SQL Server 7 / 2K both support updates via transactional replication. I.e. they either send actual SQL UPDATE statements or call custom stored procedures passing them the data that has changed. They also support "update replication", which is a horse of a different color. Hope I understood your question correctly.
March 2, 2004 at 6:23 am
Thanks. In pre-Version7, in transactional replication the SQL UPDATE statement was not used; rather, it was DELETE 'old' then INSERT 'new'. So if one, say, updated a row and changed state from 'MASS' to 'MA' on the publisher, then the transaction passed to the poor subscriber was 'DELETE from table where uniqueid = n; INSERT into table where uniqueid = n'. Which caused some mightly ugly locking and thrashing on the subscriber's side some days. This looks much calmer. thanks again
esc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply