New Microsoft SQL Server Video Tutorial: Database Compatibility Levels and sp_dbcmptlevel

Database Compatibility Levels and sp_dbcmptlevel - view details

Database Compatibility levels are very important when upgrading from SQL Server 2000 to 2005 or 7.0 to 2000, for example, but db compatibility levels are also important for software testing and unit testing. You can test your applications that run on SQL Server 2005 as though they were running on SQL Server 2000 - a very handy backward compatibility feature!

NOTE: This video is shot using SQL Server 2005 but the concepts are valid for all versions of SQL Server

Highlights from this video:

• Valid compatibility levels
• How to force SQL Server Management Studio (SSMS) in SQL Server 2005 to use the 65 compatibility mode
• sp_dbcmptlevel and its parameters
• Upgrading and migrating from previous versions
• Backwards compatibility options in SQL Server

and much more

• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 11:25 (0.00MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video