Install SQL 2000 from 2005...I heard it can be done

[JaredL]

So I ordered SQL 2005 for when my company goes to a new EMR, but I need to have SQL 2000 for three months prior. I was told that there is way to install 2005 and allow it to be backward compatible or install 2000 using the licensing from 2005 and then just switch to 2005 in 3 months. Any thoughts on how to do this?

JARED

 

[ptheriault]

If you install SQL 2005 you would set the db compatibility mode to 8.0.
Right click on the database and select properties -> options
and change the Compatibility level to SQL Server 2000 (8.0)

This mode is only per database and will not have an impact on other datbases on the server.


- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

When you purchase SQL (or just about any Microsoft product) you have the right to downgrade for free. This means that if you can get your hands on a copy of SQL 2000 (through any means possible) you can legally install it using the SQL 2005 license (not the key).

You can then upgrade the server using the SQL 2005 software that you purchased for free as you already have the SQL 2005 license.

I have an FAQ out there on licensing but at the moment it doesn't cover downgrading. I'll try to get that added shortly for you. The FAQ can be found here faq962-5153.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com