Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Upgrade from SQL Server 2008 Standard to Developer?

I have installed SQL Server 2008 Standard edition and I want to upgrade it to Developer version. I installed the Standard version for my MSDN subscription. I have tried to upgrade from the Standard ISO and Developer ISO and it does not give you an option to upgrade. It ask for a product key but MSDN states "No key is required for this product" for Developer version. This should be real simple. How do I upgrade from Standard to Developer using the ISO's on my MSDN subscription?

like image 208
Lakeshore Avatar asked Jun 09 '11 02:06

Lakeshore


People also ask

How do I change SQL Server Standard Edition to developer?

To upgrade an existing instance of SQL Server to a different edition, from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade. If Setup support files are required, SQL Server Setup installs them. If you are instructed to restart your computer, restart before you continue.

Can we directly upgrade SQL Server 2008 to 2019?

SQL Server 2019 is not supported on Windows Server 2008 R2, which is in any case heavily out-of-date and insecure. If you wanted to go with a direct upgrade path for your existing server, you must: First upgrade the operating system to Windows Server 2012 R2.

Is SQL Server 2008 Developer Edition free?

Is SQL Server Developer Edition free? Yes, it is. It is a free edition used for non-production environments.

Can we directly upgrade SQL Server 2008 to 2016?

SQL Server 2016 supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later. SQL Server 2008 R2 SP3 or later. SQL Server 2012 (11.


2 Answers

Just install the developer version next to the standard version. You can uninstall the standard edition if you want. The database .mdf files can be used by either. Detach them from the standard edition and attach them to the developer edition.

like image 60
Nik Avatar answered Oct 13 '22 02:10

Nik


You should just be able to do it using the "Edition Upgrade" option from the Maintenance portion of the Installation Center.

If that doesn't work, you might also try constructing a command line to the setup program, using /ACTION=editionupgrade, among other parameters.

like image 24
Damien_The_Unbeliever Avatar answered Oct 13 '22 03:10

Damien_The_Unbeliever