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?
2
-
4There's absolutely no impact at all. The only thing that changes is that some additional features in SQL Server become available, so your performance might get better in certain areas, or you have more options to performance tune your queries.– marc_sCommented Nov 17, 2014 at 10:17
-
Just want to highlight, that upgrading is easy, but have you justified that Enterprise Editions is the right choice - what other features you are going to use ? It adds up the licensing cost as well.– Kin ShahCommented Nov 17, 2014 at 15:10
Add a comment
|
1 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.
answered Nov 17, 2014 at 15:06
