none
The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication. SQL2012 - SQL2016 RRS feed

  • Question

  • Hi All

    i have recently set up a server with SQL2016 and need to start replicating from a SQL2012 remote server. i have set up an alias for the server SQL2016 and i receive the below when ever i try to set up the subscription.

    TITLE: New Subscription Wizard
    ------------------------------

    The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    any help would be appreciated.

     
    • Moved by Tom Phillips Tuesday, May 16, 2017 11:35 AM Replication question
    Friday, May 12, 2017 6:27 AM

Answers

  • You wont be able to create subscription from SSMS 2012 to a subscriber with higher version (in your case 2016). you have two options:

    1) use 2016 SSMS

    2) use T-SQL (sp_addsubscription etc.). When using t-sql you should be able to create subscription from 2012 SSMS.

    Tuesday, May 16, 2017 8:06 PM

All replies