Post reply

Replication from 2008 R2 to 2014, is it possible?

  • February 11, 2016 at 12:33 pm

    #304660

    I have been asked to set up transactional replication from our current Production environment (SQL Server 2008 R2) to a "new" replication environment which will be SQL Server 2014.

    First, is it possible.

    Second, anything I need to watch out for?

    Thank you for all of your help.

    And yes, this set up would be temporary as we are upgrading our production environment in a few months but the Infrastructure Guru's want to build out the new server now...

  • February 11, 2016 at 1:33 pm

    #1858162

    chris.munsell (2/11/2016)

    First, is it possible.

    Yes

    Second, anything I need to watch out for?

    Having done this recently, multiple times, make the distributor SQL 2014 and do the entire setup from Management Studio on that server (i.e. SSMS 2014)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 12, 2016 at 6:21 am

    #1858320

    Thank you for the answer and recommendation Gail!

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

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