0

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?

migrated from stackoverflow.com Nov 17 '14 at 10:51

This question came from our site for professional and enthusiast programmers.

  • 4
    There'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_s Nov 17 '14 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 Shah Nov 17 '14 at 15:10
3

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):

enter image description here

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.