locked
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

  • What type of replication? You can find the supported version mixes for different replication types here: https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Friday, May 12, 2017 6:49 AM
  • Hi TiborK

    i am using a Transactional publication of the SQL2012 database to SQL2016 

    Tuesday, May 16, 2017 1:58 AM
  • That should be supported, according to the blog article I linked to. I would make sure that I'm up to date on service pack and if the message persists after that I would report this to connect.microsoft.com.

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Tuesday, May 16, 2017 10:40 AM
  • This works fine for me.

    The alias is to the subscriber - correct? The alias should be to the subscriber and not the publisher. You may find that you may need to create the alias for both 32 bit and 64 bit.

    Tuesday, May 16, 2017 11:04 AM
    Answerer
  • Please see:

    https://blogs.msdn.microsoft.com/repltalk/2016/08/12/suppported-sql-server-versions-in-replication-topology/

    Tuesday, May 16, 2017 11:36 AM
  • 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
  • I think Bartosz is correct. I was able to do this, but I was using SSMS 2017.
    Tuesday, May 16, 2017 8:18 PM
    Answerer