Link to home
Start Free TrialLog in
Avatar of mrlevesque
mrlevesque

asked on

MSSQL 2000 Server vs. MSSQL 2005 Compatibility Mode

Greetings,
Can anyone explain to me the difference between running a database on a SQL 200 server vs running the same database on a SQL 2005 server in SQL 2000 (80) mode.
We are trying to move our various databases on to a single, high powered SQL 2005 Cluster. Some of the older servers are running SQL2000. I would think that I could move a SQL 2000 database to the new cluster and run it in compatibilty mode, but I am getting resistance from a few vendors.

Thanks
Avatar of matrix_aash
matrix_aash
Flag of United Kingdom of Great Britain and Northern Ireland image

It easy to configure it. Right click the database and change the compatibilty to Sql Server 2000.
 Lot of people run it like this. I dont think there is any problem in doing so.

Cheers.
ASKER CERTIFIED SOLUTION
Avatar of MohammedU
MohammedU
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial