We are using SQL Server 2008 R2 Standard edition with Visual Studio 2010 (Web API). Also we have created SSIS packages using business intelligence. If we decide later on to upgrade to SQL Server 2008 R2 Enterprise edition, what is the process and the impact on the .NET environment?
Sql-server – Upgrading SQL Server 2008 R2 Standard edition to SQL Server 2008 R2 Enterprise edition what is the process and the impact
sql serversql-server-2008-r2
Related Question
- Sql-server – Downgrading SQL Server 2008 R2 Standard to Web Edition
- Sql-server – Upgrade BI server to 2014 and stay on 2008r2 with the database engine server
- Sql-server – Will SSDT-BI work with SQL Server 2008 R2
- Sql-server – Business Intelligence Development Studio installation for Visual studio 2010 problem
- Sql-server – Encrypted data using MS SQL SERVER 2008 R2 ENTERPRISE EDITION. Can we decrypt data using 2008 R2 STANDARD VERSION
- Sql-server – Upgrade from SQL Server 2008 R2 Enterprise to SQL Server 2016 Standard Edition
- Sql-server – SQL Server 2008 R2 Edition Upgrade Process
- Sql-server – How to upgrade SQL Server 2016 and 2017 Standard to 2017 Enterprise edition
Best Answer
The process is simply to launch SQL Server setup from your DVD or ISO, go to the Maintenance tab, and perform an "Edition Upgrade" (please ignore the fact that this screen shot is from SQL Server 2014):
You'll need to enter a different product key.
Please also make sure you install the latest service pack (SP3; 10.50.6000).
As for impact, you shouldn't expect any negative impact at all, except that perhaps you will need to bounce the service as a part of installation.
More info on edition upgrades.
If this doesn't work out, you could always install a brand new instance of SQL Server with a different instance name, then backup and restore your user databases (and copy linked servers, job, and logins). But that really should be a last resort - if you have an issue with an edition upgrade, come back with a more specific question.