SQL 2012 Express to SQL 2012 STD Upgrade

gwa60060 used Ask the Experts™
Here's the situation.
I have a hosted server running Server2008R2/SQL 2012 Express. The application's database has reached the 10g limit so  SQL Express is no longer working. Additionally, the System drive that hosts both the SQL Express application and the database has only 1g free space. What I want to do is-
1-Move the existing database to the Data drive which has plenty of free space
2-Upgrade to SQL2012 STD & move the application install path to the Data drive as well
3-Reattach the moved database to the new SQL STD installation

Is this as straightforward as it might appear? Any gotchas? the 10g database is backed up already.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
You can perform an in-place upgrade so the binaries of SQL Server STD will overwrite the Express Edition. Just run the setup.exe from STD and chose the option to upgrade a SQL Server instance.
After upgrade, detach the database, copy the files to the new location and attach them back to SQL Server instance.


Sorry - forgot to give credit for answer.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial