Transactional Replication

  • rogelio.vidaurri

    SSCrazy

    Points: 2114

    Hello,

    We currently have 5 databases being replicated bidirectionally to another SQL Server instance using SQL Replication - Transactional (via T-SQL scripts). Both instances are running SQL Server 2012 Standard. Long story short: we back up a database in instance A, and then we restore it in instance B which then will synchronize the "delta", some scripting in between.

    When we affect instance A's databases those transactions go immediately to instance B's databases and vice versa.

    We need to upgrade both instances to SQL Server 2017 Standard with no downtime. Could we generate this type of replication from SQL 2012 to SQL 2017? I mean, from instance A to instance C, then from instance C to instance D and finally shutting down instances A and B?

    Regards

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Jeff Moden

    SSC Guru

    Points: 995467

    I've not checked but even if the documentation and every MVP in the world said "Yes, that'll work",  I'd try it on a couple of test systems first.  My recommendation is to cut to the chase and try it on a couple of test systems now.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • rogelio.vidaurri

    SSCrazy

    Points: 2114

    I found yesterday that it could work from 2012 to 2016, and then to 2017.

    We'll give it a try.

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

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