Downgrading SQL2005 to 2000

~J~ · 13 Oct 2006 at 00:15

Installed Vista on my machine only to realise that SQL2000 can't be run as a server within this OS.

I've got VS2005 which comes with SQL2005 Express and was wondering if there was any MAJOR differences between the two engines.

I have a lot of databases, that use stored procedures in SQL2000 format and was wondering if these can be converted or attached in SQL2005 Express, worked on, and then converted back to SQL2000.

Alternatively, anyone had any joy in running SQL2000 in Vista?

toString · 13 Oct 2006 at 10:19

I'm pretty sure this is of no help, but I've done an upgrade from 2000SE->2005SE on a 2003 server and all the databases+stored procs. were converted perfectly.

McMuffin · 14 Oct 2006 at 13:06

In SQL 2005 you can run it in 2000 compatability mode, also I believe it is possible to run SQL 2K5 and 2k on the same server and setup a linked server between the two for testing of stored procedures etc...

Most 2000 derived SQL DB's should function fine on 2005. I have upgraded both 2000 and WMSDE DB's to 2005 express with no problems.

~J~ · 14 Oct 2006 at 18:57

Tried and tested this today after a bit of hassle but happy to say it works an absolute charm!

Thanks for the help.