I want to upgrade SQL server from 2008 to 2014 versiyon. I checked all of the deprecated features including raiserror syntax. But I have many stored procedures to check. Some of them use new syntax, some of them use old syntax and I need to alter the old syntax from them. How can I check all of the procedures to detect old raiserror syntax?
SQL Server 2008 – Deprecated RAISERROR Detection
deprecationraiserrorsql-server-2008upgrade
Related Question
- Sql-server – SQL Server 2005-2008 Compatibility Check
- Sql-server – Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that’s in 2000 (80) compatibility mode
- Sql-server – Which one to consider for upgrade SQL Server 2008 vs SQL Server 2014 or Compatibility level 100 vs 110
- SQL Server – Restore SQL 7 Database into SQL 2014 Without Intermediate Versions
- Sql-server – How to upgrade SQL Server 2008 to SQL Server 2014 servers with mirroring configured
- MySQL – How to Copy Schemas to a New Version Instance
- Sql-server – Side By Side Upgrade and Migration from 2008 to 2016
Best Answer
Below is a PowerShell script example that uses the T-SQL Script DOM parser to parse all existing T-SQL modules in the specified database and display errors if any cannot be parsed for the target SQL version. This will identify discontinued syntax for
RAISERROR
and any other discontinued T-SQL syntax as well.