Upgrading SQL Server 2012 to 2014 with Cluster and Replication

Last week while browsing an interesting question. The question was “A user is having SQL Server 2012 on Cluster and Replication”. The user wanted to upgrade the SQL Server 2014. The answer to this question is yes, Upgrading SQL Server 2012 to 2014 with Cluster and Replication is possible, very much possible. However there are few things that needs to be consider, they are:

  1. Always make sure that you run SQL Server Data Migration Assistant (DMA)
  2. Refer SQL Server Upgrade Generic Plan and modify it to suit your need
  3. Review the link for Upgrading SQL Server FCI
  4. Review the link related to Upgrading Replication topolgy, these instructions are specific to SQL 2016 but it has a full matrix so it is very useful in case like this

Overall, it is very much possible upgrading SQL Server 2012 to 2014 with Cluster and Replication. Do test it throughly before going into production and you should be all good.

Leave a Reply

Your email address will not be published. Required fields are marked *

Hemantgiri Goswami

Hemantgiri Goswami

Hemantgiri is a seasoned SQL Server Consultant with demonstrated history for close to 21 years. He is a published author specializing in High Availability and Disaster Recovery area. He was awarded Most Valuable Professional by Microsoft 4 times. He is a regular speaker at events in Surat. Hemantgiri is founder and leader of the SQLPASS Chapter for Surat.