Downgrade SQL Editions

[ms1746]

I have a server that is running SQL Server 2000 Enterprise Edition and the customer wishes to downgrade to SQL Server 2000 Standard Edition. What is the easiest way to do this...is it possible to do it without uninstalling and reinstalling SQL Server completely?

Thanks for any help!!!

 

[MDXer]

Apart from possible license issues you would need to know what advanced features if any are in use.

this link shows the differences between the versions

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Cranger]

Going back to the original questions...

Is there a way to do this?

 

[Corran007]

As far as i know, you have to unistall it and resinstall it

 

[Cranger]

OK, so basically, I can copy the backups (or tables), to a different directory....Uninstall, reinstall standard...then reattach?

 

[Corran007]

Yes. You will not be able to restore your msdb because they are different. Dont forget to script out all your logins or you will have to remake them.

So script off your logins, save any dts packages off to anohter server if you can, otherwise its harder to get em saved but still doable. script out all your jobs that are not part of a maintenance package, detatch your prod databases. save everthing off to elswhere. unistall sql server, id proably reboot, reinstall sql server, install sp3. start rebuilding. logins first, then databases, then the rest.

simple enough