Close this search box.

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 *

Picture of Hemantgiri Goswami

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.