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

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 14 hours 49 minutes ago
• Marked as answer by Asolano016 14 hours 15 minutes ago

1. https://msdn.microsoft.com/en-us/library/ms143393.aspx
2. I do not understand what is being asked. Perhaps you are looking for https://msdn.microsoft.com/en-us/library/cc280407.aspx or https://msdn.microsoft.com/en-us/library/ms143179.aspx?f=255&MSPPError=-2147217396
3. This search https://support.microsoft.com/en-us/search?query=%22sql%20server%202016%22%20kbqfe currently returns no relevant "known issue".
4. Use a support search or an msdn search or a TechNet search similar to above. The acronym "kbqfe" can be useful for support searches. The phrases "cumulative update", "service pack", and "hotfix" are also useful