Post reply

Source control and transactional replication - what's the best way

  • November 2, 2017 at 2:34 am

    #329401

    Hi,

    What's the best way to deal with transactional replication especially when deployment script contains drop and create commands for specific articles. Should i just generate a script to drop all articles and re-create them straight after running rollout scripts?

  • December 7, 2017 at 10:16 am

    #1971211

    I tend to do this, mostly because replication is fragile and it's often easier to rebuild than fix something that's broken.

  • December 7, 2017 at 11:10 am

    #1971233

    Thanks Steve,

    I Wrote pre and post deployment scripts to deal with this.
    Pre deployment script drops all table articles leaving the replication in place and Post deployment adds them all back marks subscriptions for reinitialization, makes new snapshot etc. seems to be working fine for now.

  • December 7, 2017 at 1:47 pm

    #1971275

    That's what I tend to recommend. Easier and more consistent than debugging the semi-regular failure of repl after a deployment.

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

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