I have a client that is having plans to upgrade/migrate the SQL Server instances from 2008 R2 to 2012. I have provided the details as below. The environments are all Virtual running OS version Windows 2008 r2 enterprise SP1 and uses VMWare.
SQL003 - SQL Server 2008 r2 instance on a WSFC. This SQL Server instance is a publisher with local distributor and subscriber to 2 places
SQLDR003. It also has some databases which are both in replication and also part of Mirroring to the DR site (
SQL007 - SQL Server 2008 R2 instance on a WSFC. This SQL Server instance is a publisher for
SQL008 and is also a subscriber to
SQL003 as noted above as well.
SQL008 - SQL Server 2012 SP1 is a standalone SQL Server instance. I am not too concerned about this instance.
I know that in order for me to move forward with upgrading to SQL Server 2016 the 0S needs to be at least Windows 2012 OS OR later. I am thinking down my head how to achieve this. Is it possible if I can directly upgrade the OS to Windows 2012 or 2016 and then patch SQL Server to 2016 but then how about replication and stuff will this break anything etc or do I need to rebuild a cluster completely and then migrate the objects. It would not be an ideal spot to migrate the databases and all the associated objects based on how the environment is configured. I am in need of some methodology that can save me time and with no changes to the existing hostname etc.