Solved

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

Posted on 2009-07-14
2
3,038 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
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IN with @variable 5 25
Troubleshooting Methodology - steps 3 36
Authentication error 1 38
TSQL previous 5 21
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

947 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now