not supported query in sql server 2016

Copper Contributor

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..

1 Reply

@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