none
SQL Server 2005 upgrade & migrate to 2012 method

    Question

  • Hi,

    The situation is like this:

    Currently I have SQL Server 2005 on an old Windows Server 2003. The target is to let SQL Server 2012 on Windows Server 2012 with the databases migrated over. The new server with Windows Server 2012 was prepared.

    Originally my plan is to install SQL Server 2005 on the new Windows Sever 2012 first, migrate the database from old server to here, then upgrade SQL Server to 2012. Then found out this method cannot be used due to SQL Server 2005 is not compatible with Windows Server 2012.


    Alternative suggestions are appreciated.

    Sunday, March 23, 2014 1:12 AM

All replies

  • Hello,

    1. Upgrade the old computer to Windows 2008 SP2.
    2. Upgrade the instance in the old computer to SQL Server 2012.
    3. Perform a side-by-side upgrade to the new instance/computer.


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Sunday, March 23, 2014 2:27 AM
    Moderator
  • Hello,

    1. Upgrade the old computer to Windows 2008 SP2.
    2. Upgrade the instance in the old computer to SQL Server 2012.
    3. Perform a side-by-side upgrade to the new instance/computer.


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Thanks for your suggestion. Is there anyway other than involving Windows Server 2008 / SQL Server 2008 for this task?

    Sunday, March 23, 2014 6:05 AM
  • SQL Server 2012 supports upgrade from the following versions of SQL Server:

    SQL Server 2005 SP4 or later
    SQL Server 2008 SP2 or later
    SQL Server 2008 R2 SP1 or late

    So please make sure that your existing sql server 2005 is upgraded to SP4 or later.

    Then best way is use side by side.

    Windows Sever 2012 on you new machine and sql server 2012.

    Then use side by side method to migrate your old sql 2005 to new version 2012, ( moving backups and restore, logins, jobs, packages, configurations, maintenance plans, linked server details and more. )

    If you use in-place the in case of any issues we cant do anything to bring back the server to old version or fixing the issue may take lot of time. side by side its matter of navigating the connection and changing the connection setting for application and putting databases for use ( online from single user or may be from online to online )


    Raju Rasagounder MSSQL DBA

    Sunday, March 23, 2014 12:38 PM
  • Hello,

    No to my knowledge.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Saturday, March 29, 2014 9:19 PM
    Moderator