Post reply

MSSQL 2000 ES Replication

  • June 30, 2010 at 5:18 am

    #234448

    Dear all,

    I'm trying to implement replication but whenever I try to do that using Enterprise Manger, it is adding a new Column to many of my tables which cause INSERT, UPDATE, DELETE to fail. Am I missing something or do tables have to be designed for replication from the scratch?

    Much appreciated.

  • June 30, 2010 at 9:45 pm

    #1187436

    Sounds like you are using either Merge Replication . This requires a uniqueidentifier column and replication will add the column if needed.

    If you need to have updates to records at the subscriber, you don't have a choice. However, if the data is read only at the subscriber, then transactional replication might be a better choice.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply