Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2014-05-19 : 07:38:26
|
| HiI have a database thats currently in a SQL Server 2008 set to compability level 80 (Sql Server 200), what happends if I change it to compability level = sql server 2008? Can the database stop working or what do I need to consider? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-19 : 08:16:26
|
there is a database upgrade advisor http://technet.microsoft.com/en-us/library/ms144256%28sql.105%29.aspxI have never used that before, it probably can help to analyze your database and give you the required informationwhatever it is, the best way is still do it in your test environment and test out your application
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-19 : 12:12:19
|
| The database won't stop, but your application might. As KH mentioned, you need to test this first to ensure that your application is working properly. There's a possibility you may need to make a code change in order to support a higher compatibility level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-20 : 01:38:58
|
| The Upgrade Advisor is a good source of information re: compatibility levels. Basically , the compatibility level will let you use older features of SQL Server - therefore if you up the compatibility level, you may break your app. Some more information on using compatibility levels: http://www.sqlserver-dba.com/2014/01/compatibility-level.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
change compability level