Transactional Replication

  • Does Transactional Replication add any columns or anything else to the database being replicated like Merge Replication does?

  • Tim,

    No, Transactional replication itself does not alter your user table schemas.  However, published tables MUST have a primary key, so in that sense, you might have to alter the tables yourself prior to replication.

    Note, however, that (very) strictly speaking, enabling Transactional replication does change your database slightly by adding system tables such as syspublications and sysarticles. 

     

    Hope this helps,

    Scott Thornburg

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

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