Merge Replication from 2012 SQL Server publisher/distributor to 2014 SQL Express subscriber

• Anders_ss

  Newbie

  Points: 8

  More actions

  July 1, 2014 at 3:35 am

  #287409

  Hi, I'm having a question about which version to use when running SQL Merge Replication.

  In my test enenvironment have a SQL 2012 server running as Publisher and Distributor for my Merge Replication. I have now set up a test client running Win7 SQL 2014 Express as a subscriber. The subscription initializes and runs perfectly.

  But according to the SQL documentation this should not be possible as it states that the subscriber should have a version number equal or lower than the publisher. My subscription client was set up using SQL-scripting, if I try using the wizard it will just cause an error message telling that this is not possible since the client has a newer version number. I still not encountered any problems after I set it up using the script with the sp_addmergepullsubscription and sp_addmergepullsubscription_agent procedures.

  The roll-out of my solution will start in a few weeks and I now have to decide whether to use 2014 Express or 2012 Express on the clients. Using 2014 Express will save me for a lot of upgades in a year or two. The 2012 SQL Server running as publisher/distributor will be upgraded to/replaced with a 2014 Server in some few months.

  I'm looking for good advices and recommendations for what to choose on the clients, 2012 Express or 2014 Express. Are the any known problems with using 2014 Express as a subscriber to a publisher/distributor running 2012 SQL Server?

  All responses are welcome!

  Regards, Anders