Jan 20 2020 08:05 PM
Hi,
I want to upgrade SQL Server from 2008 R2 to 2016, is there a query on SQL Server 2008 R2 that is no longer supported on SQL Server 2016? ..
For example, I found that the RAISERROR function in the RAISERROR 50001 'xxx' format cannot be used anymore and must use the format
RAISERROR ('xxx', 16.1)
thanks for the answer..
Jan 29 2020 04:03 AM
@doni_ramdani have you completed a compatibility assessment of the database using the Data Migration Assistant tool - https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15