March 1, 2010 at 8:33 am
Hi,
Anybody has done upgrading SQL server evaluation edition to standard edition for SQL server 2005? Please let me know the steps to do it and is it difficult to do it?
Any kind of help will be appreciated.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
March 1, 2010 at 9:17 am
You need to migrate the database to the new standard edition. The procedure itself should not be difficult but you need to plan it ahead to ensure the migration done smoothly. Here are the major required jobs:
1. Install and configure the new instance.
2. Back up the databases, jobs, logins, and SSIS packages on the source instance.
3. Restore the databases to the new instance.
4. Perform database configuration as needed.
5. Migrate logins, jobs, SSIS packages, if any, to the new instance.
6. Set maintenance plans in the new instance.
Good luck!
March 1, 2010 at 11:43 pm
Hi,
Thanks for your reply. As per the reply I need to install SQL standard edition and need to restore all the things.
But I dont want to uninstall evaluation edition, Is it possible to enter the licence key and doing direct upgrade?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
March 2, 2010 at 12:04 am
Hi
Upgradation will do in two ways:IN_PLACE,Side-by-Side.choose any one.but side-by-side is beter one.this case two editions are working fine.
steps:
-> take the backup of all databases,logins,users
->install sql server standard edition
->restore all databases
->check the recovery model,compatibility
->if any orphaned users is there fix them using sp_change_users_login
March 2, 2010 at 7:41 am
Sumanta,
It is more suitable to do this work with side-by-side migration. In other words, install the standard edition on another server and this is more appropriate solution; if you have to use the same server for the new instance, you should install the SQL Server on the existing server as a named instance and then do the migration.
I haven't done in-place migration from expression to standard edition. It, however, is advantageous to have a live system available for a variety of reasons while doing the database migrating. And I believe side-by-side migration is a preferred option for your situation.
March 3, 2010 at 12:05 pm
Sumanta,
It is possible to run both SQL Express and SQL Server side by side on the same machine. There is no "upgrade key" for SQL Express to SQL Server, I believe that the code base is different. I would suggest that you install sql server on your machine. Then open your SQL Express edition and right click on the database names and "detach" the databases, ( make sure you know what the location and names of the actual sql file names are before doing this). Then copy these files to a new directory, (c:\sqldata\sql2005\..) Then from the SQL Server instance "attach" the copies of your databases. Once successfully attached go back to the SQL Express instance and re-attach the original databases. Now you have both editions running and you can transfer any users or other objects that need to be transferred.
see:
http://technet.microsoft.com/en-us/library/ms190209.aspx
John.
March 3, 2010 at 12:15 pm
You should check the microsoft web site to be sure, bit iirc, since the Evaluation Edition is essentially the Enterprise Edition with an expiration date I don't think you can do an in-place upgrade. Your two choices are to uninstall the Evaluation Edition and install the Standard Edition or install the Standard Edition as a named instance and follow the instructions others have already posted.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply