Home Forums SQL Server 2008 SQL Server 2008 - General Replication from 2008 R2 to 2014, is it possible? RE: Replication from 2008 R2 to 2014, is it possible?

  • 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