October 15, 2015 at 6:32 am
HI Champs,
I want to upgrade sql server 2005 to sql server 2014 . In case if some old function may not support by new versions, then how can i subsitute alternate for that ?
IS there any possibility like some old functions are removed in new version ? if yes then how to upgrade such lines of code ?
Regards,
Ravindranath.S
October 15, 2015 at 6:37 am
You will need to look through the depreciated features list and swap out the old way of doing it for the new way of doing it as detailed in books online.
EG
sp_change_users_login shouldn't be used no more, instead use ALTER USER
October 15, 2015 at 6:46 am
Thanks for the quick response 🙂
October 15, 2015 at 6:51 am
ravi@sql (10/15/2015)
Thanks for the quick response 🙂
Just make sure you check each revisions list from what your moving from to to. There maybe things listed for depreciation in 2008R2 which are not listed in 2012 as they have already been documented, so you need to check all 2008, 2008R2, 2012 and 2014 lists.
October 15, 2015 at 8:30 am
When you're all done checking everything there is to check and fixing everything there is to fix, there's just no substitute for testing, more testing and even more testing.
October 15, 2015 at 10:44 pm
Cool ...Many Thanks 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply