June 24, 2011 at 7:29 am
Hi
We just migrated from 2005 to 2008R2 developer edition. Now we plan to use compatibility level 100 for our databases.
Can anyone pls suggest what issues might arise because of this? I have gone thru the below mentioned link and dont see a problem here.
http://msdn.microsoft.com/en-us/library/ms143729(SQL.90).aspx
But still want to be sure that my procs and functions dont break when we change the level.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
June 24, 2011 at 1:34 pm
S_Kumar_S (6/24/2011)
...But still want to be sure that my procs and functions dont break when we change the level.
Wow, I hope you're not asking for people that have no idea what you're environment, data or code is like to provide some type of validation that if you change the compat level on a production database that nothing will break.
If you want to be sure, the only way to know is to test.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 3:04 pm
what was the former db level ?
If it was 90, I'm pretty confident it will work with 100.
Did you run the upgrade adviser (sqlua) ?
It will analyze and detect potential problems and does a good job with that !
Of course the only way to be 100% sure is to test _all_ your stuff with the new setting !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 27, 2011 at 12:53 am
Thanks ALZDBA. I'll run the advisor. Previous level was 90.I too hope that 100 should not be a trouble either. Moreover it is Dev and QA environment, so not a big problem.......thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply