Home > IT Answers > Development > Migrate FROM SQL2005 Ent. TO SQL2005 Standard
Jtncat
5 pts.
 Migrate FROM SQL2005 Ent. TO SQL2005 Standard
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.

Software/Hardware used:
ASKED: November 14, 2008  3:28 PM
UPDATED: November 14, 2008  8:08 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  November 14, 2008  8:08 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _