We have a development server that was initially setup with SQL Server 2008 SP2 Standard Edition. Is it possible to upgrade that edition to 2008 R2 Developer Edition so we can play with the extra features in Developer Edition?
1 Answer
You can't change the version of the installed instance as far as I know, but you could install a second instance with the Dev edition, or uninstall the Standard edition, install Developer edition and attach the user databases.
-
1I tested this and you are mostly correct. You can only upgrade to a non-dev edition equal or higher than you already have. Docs: msdn.microsoft.com/en-us/library/ms143393.aspx– Mike LJan 17, 2011 at 14:34