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?
Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition
sql-server-2008sql-server-2008-r2
Related Solutions
Indeed SQL Profiler is available in SQL Server 2008 Developer Edition.
The features supported by SQL Server Enterprise, Developer, and Evaluation are the same.
Likely you'll have to go back into the SQL 2008 installer and modify the installation options to include the Management Tools - Complete features. If this feature is not selectable, you may have installed a lower edition (such as Express). You'll need to perform an edition upgrade on the shared features, then run the installer again. The feature should now be selectable.
From the Windows Small Business Server Editions Overview (near the bottom of the page):
- SQL Server 2008 R2 for Small Business featuring a range of features that can help businesses maximize the value of their information with greater capabilities in development, manageability, business intelligence, and data warehousing. SQL Server 2008 R2 for Small Business has exactly the same capabilities as SQL Server 2008 R2 Standard, however it is only available to use in the SBS 2011 environment.
The key being the last line, only available for SBS. If you want just SQL with nothing else then you'll have to buy a normal SQL Server Standard license.
(It would be nice if Microsoft would also mention it on the SQL Server Editions Overview as well.)
Best 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.