locked
SQL Server up gradation 32-bit to 64-bit possible or not RRS feed

  • Question

  • Hi 

    In Side By Side Migration or up-gradation can databases of 

    SQL Server 2005 (32-bit) Migrate to --> SQL Server 2008 (64-bit) / 2008 R2 (64-bit)  ?

    SQL Server 2005 (32-bit) Migrate to --> SQL Server 2012 (64-bit) / SQL Server 2014 (64-bit) ?  

    SQL Server 2008 (32-bit) Migrate to --> SQL Server 2012 (64-bit) / SQL Server 2014 (64-bit) ?

    Regards,

    Nikhil P Desai


    Tuesday, November 8, 2016 4:02 PM

All replies

  • Hi,

    There's no automated migration from SQL 32 bits- to SQL 64-bits.

    You'll have to install a separate server (or instance) running SQL 64-bits, backup your 32-bit user databases

    and restore them on the 64-bit server (or instance).

    Be aware that you'll also have to script out system objects (like logins and scheduled jobs) and reapply them

    on the destination server.

    • Proposed as answer by Naomi N Tuesday, November 8, 2016 4:41 PM
    Tuesday, November 8, 2016 4:09 PM
  • Please see:

    https://msdn.microsoft.com/en-us/library/ms143393.aspx?f=255&MSPPError=-2147217396#Unsupported Scenarios

    SQL Server 2016 is only available for 64-bit platforms. Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in replication. You must re-create any logins and other user objects in master, msdb, and model system databases.

    • Proposed as answer by Naomi N Tuesday, November 8, 2016 4:41 PM
    Tuesday, November 8, 2016 4:21 PM