Link to home
Start Free TrialLog in
Avatar of LGroup1
LGroup1

asked on

How difficult is MS SQL Server 2005 to MS SQL Server 2012 upgrade/migration ?

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
ASKER CERTIFIED SOLUTION
Avatar of Michael Dyer
Michael Dyer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LGroup1
LGroup1

ASKER

This is perfect, thanks all !