• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Verify Level 100 Compatibility of Databases

I switched from SQL Server 2005 to SQL Server 2008 already. I only found out about the Upgrade Advisor after I had made the switch and the Upgrade Advisor doesn't seem to work with SQL Server 2008. My databases are still set with a compatibility of 90. Is there a simple test I can run to see if it's okay to switch to level 100?
0
quizwedge
Asked:
quizwedge
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes, you can run a profiler trace and capture the Deprecated events to decide whether you are good enough to change your Compatibility level to 100. Use the below link to run Profiler trace to capture so.
http://www.mssqltips.com/sqlservertip/1370/identifying-deprecated-sql-server-code-with-profiler/

Run the profiler trace for 2 days or max a week and check for commands involved. If you don't have any, then you can safely switch Compatibility level to 100.
0
 
quizwedgeAuthor Commented:
Excellent. Thanks!
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
And another note, make sure you do all kind of transactions or events from your application so that you will capture and verify all events in your database to decide it completely.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now