Migrate FROM SQL2005 Ent. TO SQL2005 Standard

5 pts.
Tags:
SQL
SQL 2005
SQL Server
SQL Server 2005
SQL Server 2005 Enterprise Edition
SQL Server migration
We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do this. I am looking for some help with best practices or how to's. Any advice will be greatly appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you were running the 180 Eval edition then you can go a SKU upgrade to Standard Edition. Put the DVD in the drive, and cancel out of the installer. From the Start > Run, run d:\setupe.exe /SKUUPGRADE where d is the drive letter of the CD/DVD drive.

If you have the actual Enterprise Edition installed you will need to uninstall and reinstall SQL Server.

In either case after the installer has finished you will need to reinstall the service pack and hotfix that you were running before.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following