How difficult is MS SQL Server 2005 to MS SQL Server 2012 upgrade/migration ?
Posted on 2014-10-27
How difficult is a Windows Server 2003 with MS SQL Server 2005 to Windows Server 2012 with MS SQL Server upgrade/migration ? If one can do a side-by-side upgrade (and has weeks or months to do it) can it be reasonably done in one jump ? Or should one first upgrade/migrate from Windows Server 2003/MS SQL Server 2005 to Windows Server 2008/MS SQL Server 2008 and then do another full upgrade to Windows Server 2012/MS SQL Server 2012 ? Trying to do an intermediate upgrade to Windows Server 2008/SQL Server 2008 seems to be a lot of extra effort (for not much return). Is there a Wizard that can upgrade from SQL 2005 to SQL 2012, and is the upgrade from MS SQL Server 2005 to MS SQL Server pretty straightforward for a full-time DBA and is that a reasonable upgrade path and task for a full time DBA ? TIA