locked
Migration: SQL server 2005 to 2014 (from x32 bits server to x64 bits server) RRS feed

  • Question

  • Current server is SQL 2005 SP4 Standard (x32 bits) running on Windows Server 2003R2 (x32 bits).

    We would like to move the databases to a fresh install on server running 2012 R2 (x64 bits) with SQL server 2014 Standard (x64 bits).

    Kindly point me to the correct documentation.

    Thanks


    • Edited by ReMark-IT Wednesday, June 4, 2014 1:10 PM
    Wednesday, June 4, 2014 1:00 PM

Answers

  • Current server is SQL 2005 SP4 Standard (x32 bits) running on Windows Server 2003R2 (x32 bits).We would like to move the databases to a fresh install on server running 2012 R2 (x64 bits) with SQL server 2014 Standard (x64 bits).

    Cross platform In place upgrade is not supported so you cannot do inplace upgrade of 32 bit SS2005 Sp4 to 64 bit SS 2014. But you can take backup of SQL server 2005 database and restore it on 2014 database. You need to perform side by side upgrade

    1. Get new box and install SQL server 2014

    2 Move databases using backup restore method

    3 Script out logins and jobs by right click on jobs script job as ..create to..new query editor window this will give you script for the job and logins

    http://support.microsoft.com/kb/918992

    4 Migrate SSIS packages if any

    http://msdn.microsoft.com/en-us/library/cc280546.aspx

    Complete reference document

    http://msdn.microsoft.com/en-gb/library/bb677622.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles



    • Marked as answer by ReMark-IT Wednesday, June 4, 2014 2:35 PM
    • Edited by Shanky_621MVP Wednesday, June 4, 2014 3:30 PM
    Wednesday, June 4, 2014 1:25 PM

All replies

  • In SQL Server 2014, you can create a new database by restoring a backup of a user database created by using SQL Server 2005 or a later version. However, backups of master, model and msdb that were created by using an earlier version of SQL Server cannot be restored by SQL Server 2014. Also, SQL Server 2014 backups cannot be restored by any earlier version of SQL Server.

    http://msdn.microsoft.com/en-IN/library/ms190436.aspx

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Wednesday, June 4, 2014 1:12 PM
  • Current server is SQL 2005 SP4 Standard (x32 bits) running on Windows Server 2003R2 (x32 bits).We would like to move the databases to a fresh install on server running 2012 R2 (x64 bits) with SQL server 2014 Standard (x64 bits).

    Cross platform In place upgrade is not supported so you cannot do inplace upgrade of 32 bit SS2005 Sp4 to 64 bit SS 2014. But you can take backup of SQL server 2005 database and restore it on 2014 database. You need to perform side by side upgrade

    1. Get new box and install SQL server 2014

    2 Move databases using backup restore method

    3 Script out logins and jobs by right click on jobs script job as ..create to..new query editor window this will give you script for the job and logins

    http://support.microsoft.com/kb/918992

    4 Migrate SSIS packages if any

    http://msdn.microsoft.com/en-us/library/cc280546.aspx

    Complete reference document

    http://msdn.microsoft.com/en-gb/library/bb677622.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles



    • Marked as answer by ReMark-IT Wednesday, June 4, 2014 2:35 PM
    • Edited by Shanky_621MVP Wednesday, June 4, 2014 3:30 PM
    Wednesday, June 4, 2014 1:25 PM