CODEWITHSUNDEEP
sql-server-2008syntaxmigrationsql-server-2014raiserror
serdartu
serdartu

Reputation: 41

SQL Server 2008 to 2014 RAISERROR migration script

Between SQL Server 2014 and SQL Server 2008 there is an issue with RAISERROR syntax.

Are there any scripts for RAISERROR syntax migration to SQL Server 2014, or database tool to migrate SQL Server 2008 to 2014?

Best regards

Upvotes: 2

Views: 2076

Answers (1)

Amit Udiya
Amit Udiya

Reputation: 11

Both RAISERROR and THROW statements are used to raise an error in Sql Server.

The journey of RAISERROR started from Sql Server 7.0, where as the journey of THROW statement has just began with Sql Server 2012. Obviously, Microsoft has suggesting we start using THROW statement instead of RAISERROR. THROW statements seem to be simple and easier to use than RAISERROR. RAISERROR can’t be used in the Sql Server 2014′s natively compiled Stored Procedures.

Upvotes: 1

Related Questions