locked
Is possible to migrate from SQL Server 2008 to SQL Server 2016? RRS feed

  • Question

  • Hi,

    In my job we are planning to make a migration from SQL Server 2008 to SQL Server 2016, so we have the following questions:
    1. Is possible to make the upgrade for those versions? If it is not possible, please explain why?
    2. Does this migration can show issues? If yes, please explain why?
    3. Can you provide me some known issues that SQL Server 2016 is showing in relation with the usage of the application or with an upgrade with any other version of SQL Server?
    4. Does Microsoft have a list of possible issues with SQL Server 2012, 2014 or 2016?

    I will appreciate any help in order to clarify this questions.

    Thanks in advance.

    Regards

    Friday, September 11, 2015 3:50 PM

Answers

  • This is a broad topic.  The short answer is "yes".  You can upgrade SQL Server 2008 servers to SQL Server 2016.  As far as the upgrade path, it varies upon the situation.  Check out the SQL Server 2016 upgrade link below for further details on how to upgrade from previous versions.

    https://msdn.microsoft.com/en-us/library/bb677622.aspx?f=255&MSPPError=-2147217396

    As far as what breaks, you will need to check out the backwards compatibility page for each product.  It details what has been deprecated, discontinued, among other things.  The link below has a dropdown that will let you change to prior versions of the backwards compatibility list.

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

    • Proposed as answer by Naomi N Friday, September 11, 2015 4:15 PM
    • Marked as answer by Asolano016 Friday, September 11, 2015 4:50 PM
    Friday, September 11, 2015 4:13 PM

All replies