Post reply

Snapshot Replication Between 2008 R2 and 2014 SSMS

  • December 16, 2015 at 1:05 pm

    #303302

    Hello,

    I am new here, and would appreciate any information any of you might have. I'm currently looking at creating a subscription on a SQL Server 2014 instance to a 2008 R2 publisher. according to a link (that i've placed below), replication is supported within 2 iterations of SQL Server. Is that correct here? Are there any issues I should expect when creating this subscription.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1216e4ec-7a66-4c80-869a-ac36b6b083fa/replication-between-sql-2014-and-sql-2000?forum=sqlreplication

    Thanks again for any responses. You all are amazing.

    Sean.

  • December 16, 2015 at 1:30 pm

    #1846423

    Should be OK. I've done transactional from 2008 R2 to 2012. iirc you'll need to ensure the distributor is on a SQL 2014 instance.

    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

  • December 16, 2015 at 3:43 pm

    #1846452

    Thank you for your timely and informative response Gail,

    In this instance it's actually for a merge publication. I just attempted to create the subscription and it gave me this error: 'For merge publications, the version of the Subscriber must not exceed the version of the Publisher.' The DB compatibility is the same, but i suspect that may not matter. Do you or anyone else know of a way around this, outside of upgrading the publisher?

    Thanks again

  • December 17, 2015 at 1:59 am

    #1846494

    I don't know merge replication, you should have said in the initial post it was for merge replication, not snapshot replication.

    I suspect the error means exactly what it says.

    the version of the Subscriber must not exceed the version of the Publisher.

    and compatibility level is not version

    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

  • December 17, 2015 at 10:50 am

    #1846623

    I had suspected as much. Thanks for taking the time to reply. Sorry I wasn't more detailed in my initial post.

    Have a good day!

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

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