After reading a recent blog from Devin Knight, here, I realized that I have only focused on the proposed new features in the CTP of SQL Server 11, codename Denali. While trying to provide insight on the new functionality I have failed to address the discontinued and/or deprecated features, the most sobering of which is DTS, as Devin summarizes in the above referenced link. Rather than duplicate what has already been published I am only going to mention a few features that will be missing in Denali and provide links to the discontinued/deprecated list(s).
The most far reaching loss is most definitely the discontinuance of DTS support. Data transformation services as well as the SSIS task to execute DTS packages is gone, as of right not at least. The ActiveX script task is also gone in Denali, time to migrate those to an existing control flow task or rewrite them within a script task. The list of discontinued SSIS functionality is outlined here.
There are some t-sql features that will also no longer be supported, such as the MS proprietary outer join syntax:
“FROM table1, table2 WHERE table1.col1 *= table2.col1”
as well as COMPUTE and COMPUTE BY clauses. The loss of such t-sql functionality can be attributed more to the discontinued support of database compatibility level of “80” as this provided the backwards compatibility for such features in recent editions of SQL. A list of these and other discontinued functionality for Denali is listed on the SQL 2008 R2 site under, “Features Not Supported in the Next Version of SQL Server” here.
A full list of all features/functionality that will be discontinued or marked as deprecated can be found online under “Backwards Compatibility” in the on-line documentation for Denali here.
While Microsoft has provided some good tweaks in T_SQL, I still believe firmly that the closer you stay to standard SQL within the T_SQL environment, the better off you are.
ReplyDelete