Solved

How do I upgrade SQL Server 2008 Enterprise Evaluation Edition to licensed Enterprise edition

Posted on 2009-07-14
2
3,051 Views
Last Modified: 2012-08-13
I have a Windows 2003 Server with SQL Server 2008 Enterprise Evaluation edition installed. The evaluation is due to expire this week so we need to upgrade to our recently procured licensed copy of SQL Server 2008 Enterprise Edition (Microsoft Volume License).

MS Would have you believe that it is possible to simply upgrade. http://msdn.microsoft.com/en-us/library/ms143393.aspx

However in testing, at the point when the upgrade tries to verify the features to be upgraded in the pre-installation section of the upgrade, an error is produced advising there is nothing to upgrade and there appears to be nothing to select for upgrade.

Ideally I would rather perform an uninstall / reinstall of SQL and restore or re-attach the original DB's. However, I am unsure whether simply restoring all of the original db's will actually restore everything that is required for the system to work. I would appreciate any advise on exactly what is required in terms of migrating data when uninstalling and reinstalling SQL Server 2008.

Many thanks
Oliver Jacobs
0
Comment
Question by:ojacobs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 50 total points
ID: 24856142
Yes you can upgrade. Use the command line setup  :  Setup.exe /q /ACTION=editionupgrade   etc...

Have a look at command line setup in : http://www.microsoft.com/downloads/details.aspx?FamilyID=66D3E6F5-6902-4FDD-AF75-9975AEA5BEA7&displaylang=en

Read the How To : http://msdn.microsoft.com/en-us/library/cc707783.aspx  lots of links and discussion as to the various scenarios, if you consider your eval edition as a "previous version", then most of it still applies.

And, there is a 490 page "book" advising best practises etc when upgrading to SQL 2008 : http://www.microsoft.com/downloads/details.aspx?FamilyID=66D3E6F5-6902-4FDD-AF75-9975AEA5BEA7&displaylang=en   might not be entirely relevant if not coming from a previous version, but a worthwhile read anyway.

Apologies for the links, and you may have read them before, but they really are the best "introduction".

Essentially what you will want to do is to take full SQL backups of your wanted databases. Uninstall the Eval, Install the full version and then restore the databases. Few little "gotcha's" - you will have to set up security / logins again, and any SSIS type packages will have to be re-established (or recreated). For that reason, it is sometimes easier to upgrade in place. If you haven't done too much additional work outside the database itself, then installing from scratch, apply patches / updates then restoring your database is a fairly "clean" start.

Let me know if you want more specific discussion once you have looked at some of the links above.
0
 

Author Comment

by:ojacobs
ID: 24859320
Many thanks for the info. I have just completed the upgrade and everythings seems to be working fine.

Your last point (full backup, un/re-install, restore) is exactly where I was heading anyway. Not being overly familiar at a scripting / t-sql level I was hoping a GUI driven approach to this would be possible as I have a lot of experience managing SQL 2000 from the management console.

I am lucky that the only DB hosted on this server is for a recently deployed SCCM environment which is not heavily utilized ... yet! As such I was able to stop the live SQL services temporarily (SQL 2008 Evaluation edition) with minimal impact and take a copy of all the DB's including Master. I copied all of these into a test environment of Vanilla SQL 2008 Enterprise Edition and all the DB's and logins were present when I restarted the SQL services. As such I mirrored this approach when upgrading the live environment from evaluation to licensed, simply stopping the SQL Services, backing up all the DB files, uninstall, re-install, stop the services, replace the newly installed vanilla Master DB with the original Master DB from backup and then starting the SQL services.

All my users and non DB specific objects seem to be present having managed to re-instate the original Master DB.

Im not sure if there were SSIS packages deployed to the initial installation of SQL as I wasnt involved but I guessed not, so there was no need to go down that route.

I have downloaded your documents and will keep for the future when I will inevitably need them!

Many thanks for the help.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question