January 9, 2013 at 8:11 am
I've got an old database (and old application) that are using a DB at compatibility mode 80.
I'm running a trace for "Deprecation Final Support" and I'm not seeing anything for that database.
Can I safely upgrade the compatibility mode on this database?
Thanks!
January 9, 2013 at 8:20 am
Deprecation Final Support and compatability level are two different things.
Compat Level tells SQL that certain commands behave in a certain way, Deprecation Final Support is for things which are being removed in a later version like sp_change_users_login or sys.sysprocesses etc.
Check the following URL for the compat differences between 80 / 90 / 100 and if the app does things which are only do-able in compat level 80, leave it in 80 otherwise you should be good to change it.
http://msdn.microsoft.com/en-us/library/bb510680%28v=sql.105%29.aspx
January 9, 2013 at 8:25 am
Okay, I was hoping the trace would throw errors for this.
I might have to dig this up
http://www.microsoft.com/en-us/download/details.aspx?id=14845
And make a VM with SQL2000 and run this tool on it.
January 9, 2013 at 8:33 am
Yup, the upgrade advisor would be where I would start as well.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply