Post reply

Side by side upgrade question

  • July 19, 2016 at 12:26 pm

    #328309

    Hello Folks,

    Is it possible to upgrade from SQL 2005 to SQL 2016 side by side?

    Thanks!

  • July 19, 2016 at 12:31 pm

    #1890934

    Is it possible? Maybe

    Is it supported? No.

    https://msdn.microsoft.com/en-us/library/ms143393.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 19, 2016 at 12:45 pm

    #1890938

    https://msdn.microsoft.com/en-us/library/ms143393.aspx

    SQL Server 2016 Support for SQL Server 2005

    This section discusses SQL Server 2016 support for SQL Server 2005. In SQL Server 2016, you will be able to do the following:

    •Attach a SQL Server 2005 database (mdf/ldf files) to SQL Server 2016 instance of database engine.

    •Restore a SQL Server 2005 database to SQL Server 2016 instance of database engine from a backup.

    •Back up a SQL Server 2005 Analysis Services (SSAS) cube and restoring on SQL Server 2016.

    When a SQL Server 2005 database is upgraded to SQL Server 2016, the database compatibility level will be changed from 90 to 100. (In SQL Server 2016, valid values for the database compatibility level are 100, 110, 120, and 130.) ALTER DATABASE Compatibility Level (Transact-SQL) discusses how the compatibility level change could affect SQL Server applications.

  • July 19, 2016 at 1:31 pm

    #1890950

    From BOL

    Any scenarios not specified in the list above are not supported, including but not limited to the following:

    Installing SQL Server 2005 and SQL Server 2016 on same computer (side by side).

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 2, 2016 at 4:10 pm

    #1893372

    AFAIK, the lowest windows version supported by 2016 is above the highest version supported by 2005, so... as was said before... not supported.

  • August 3, 2016 at 5:44 am

    #1893443

    sql server 2005 and sql server 2016 have very different OS support, so they wont reside on the same server.

    If you have a sql 2005 instance on one server and sql 2016 on another server you can attach the 2005 dbs directly to the 2016 instance, this is still technically a side by side upgrade (they don't necessarily reside on the same box).

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 3, 2016 at 7:36 am

    #1893481

    Thanks

  • August 4, 2016 at 1:56 am

    #1893682

    Pomegranate juice dark Chocolate just like blueberries, Max Synapse[/url] you could additionally make use of berries like blackberries, strawberries and raspberries to enhance the memory energy of mind. other berries encouraged to enhance the reminiscence power of brain encompass goji berries, cranberries and acai berry. Acai berry is determined to be enriched with a very good quantity of antioxidants. http://musclegainfast.com/max-synapse/

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply