September 30, 2008 at 10:04 am
Hi,
In the process of starting an upgrade project to move SQL 2000 databases to SQL 2008. The intention is to restore the production databases to a "Migration server" with SQL 2008 installed, leave the databases in compatibility mode 80 (sql2000). Make the necessary changes to the stored procs etc, test everything, change to compatibilty mode 100 (SQL2008) - test everything. Then move the databases to the new SQL2008 production environment.
The question has been raised, if compatibility mode 80 will allow the databases to function in a SQL 2008 environment without making fundamental amendments to stored procs etc, is there any inherent disadvantage in leaving them in compatibility 80 and will this allow the new SQL2008 functionality to be used? (if you see what I mean!?)
September 30, 2008 at 10:33 am
In 80 compat mode, none of the new 2005 or 2008 features will work. This includes (but is not limited to)
CTEs
Index Include columns
Table partitioning
OUTPUT clause
XML enhancements
CLR
TRY..CATCH error handling
DDL triggers
Ranking functions
DDL triggers
APPLY
Pivot
Encryption
sparse columns
filtered indexes
database compression
Spacial data types
Merge statement
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2008 at 1:41 am
Many thanks for the prompt reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply