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 comment