April 12, 2017 at 6:13 am
Hi,
I want to upgrade from Sql server 2012 to 2016. I am able to find deprecated and discontinued features/functionalities but i am not able to find in detail discontinued T-sql syntax's/commands.
Can any one suggest which T-Sql syntax's/commands will not work in 2016 which were already working in Sql server 2012.
Thanks in Advance
Kareemulla D
April 12, 2017 at 6:54 am
Take a good look here: https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 12, 2017 at 7:34 am
I don't think there's any T-SQL that worked in 12 and not 16.
What's going to bite you is the cardinality estimator changes. Make sure you test performance of the app on 16 and fix any regressed queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 13, 2017 at 12:41 am
sgmunson - Wednesday, April 12, 2017 6:54 AMTake a good look here: https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx
If you compare the below links almost every feature supporting in 2014 and 2016 even they mentioned features not supported for next versions of 2012.
https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx
https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016
So due to that reason i am looking for is there any particular link to get exactly which were avoided from 2012 to 2016.
April 13, 2017 at 1:33 am
dudekula.kareemulla - Thursday, April 13, 2017 12:41 AMSo due to that reason i am looking for is there any particular link to get exactly which were avoided from 2012 to 2016.
As I mentioned above, I don't think there are any T-SQL features that were in SQL 2012 and won't work in SQL 2016, except perhaps stuff from SQL 2000 that was already deprecated.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply