A One-Stop Post for SQL Server Upgrade Considerations
Mahesh passed along a wonderful bit of research he completed to aid in a platform upgrade, and I'd like to share it here. Here is a series of links to identify discontinued and deprecated features and behavior changes in SQL Server:
- Discontinued Database Engine Functionality in SQL Server 2008: https://msdn.microsoft.com/en-us/library/ms144262.aspx
- Discontinued Database Engine Functionality in SQL Server 2005: https://msdn.microsoft.com/en-us/library/ms144262(SQL.90).aspx
- Breaking Changes to Database Engine Features in SQL Server 2008: https://msdn.microsoft.com/en-us/library/ms143179.aspx
- Deprecated Database Engine Features in SQL Server 2008: https://msdn.microsoft.com/en-us/library/ms143729.aspx
- Behavior Changes to Database Engine Features in SQL Server 2008: https://msdn.microsoft.com/en-us/library/ms143359.aspx
I hope you find this information as useful as I do!
Thanks, Mahesh!
-wp
UPDATED 06 Sep 2008 to fix broken links (thanks to Scott R. and Scott Whigham for the heads-up!)