Post reply

SQL 2012 Transactional Replication question

  • August 22, 2014 at 11:46 am

    #397247

    Hello,

    I have implemented transactional replication in sql 2012 with replicate schema changes. Now if I drop few indexes and add columns and re add indexes on articles in publisher database does it replicate the same operations in subscriber database too?

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • August 23, 2014 at 5:21 am

    #1740463

    Sapen (8/22/2014)

    Hello,

    I have implemented transactional replication in sql 2012 with replicate schema changes. Now if I drop few indexes and add columns and re add indexes on articles in publisher database does it replicate the same operations in subscriber database too?

    Quick thought, there are some limitations, have a look at this article Make Schema Changes on Publication Databases

    😎

  • August 25, 2014 at 6:24 am

    This was removed by the editor as SPAM

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

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