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

Posted on 2009-07-14
Medium Priority
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
Question by:ojacobs
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
LVL 51

Accepted Solution

Mark Wills earned 150 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.

Author Comment

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.

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

777 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