I'm upgrading my databases to compatibility level 100 on SQL Server 2008 R2. My next step is to check if my stored procedures, functions, views, triggers are still working properly. Running each of these is not an option.
How should I check?
Asked
Active
Viewed 1,556 times
2 Answers
1
Your question is too wide I am not sure a clear answer can be given but I would try. As such sitting from here I cannot tell you what could break after chaning compatibility level. Only you can find it out by running each and evry procedures,functions, views and triggers you have.
Microsoft has documented breaking changes in SQl server 2008 R2 before changing the compatibility level you must go through this article.
You must also read Change database compatibility level BOL document to see what could get affected after changing compatibility level. Please read complete article most of the things are documented.
Did you ran upgrade advisor before you migrated database to 2008 R2 ? that should as well have pointed out breaking changes.
The good thing with compatibility level is it can be immediately changed to previous value if you face issue. So you also have got hit and try method to check out
Shanky
- 19,148
- 4
- 37
- 58
0
There has been no changes to structures or schema of "stored procedures, functions, views, triggers " , so you do not really have to change anything. If you were going from 2008R2 to 2012, all you have to worry about is the date functions. The rest is backward compatible.
LearnByReading
- 711
- 10
- 26