I have a Windows Server 2012 R2 Standard that is running SQL 2012 Express.

How do I go about changing it to be SQL 2012 Standard?

I have the media (and ISO image) and it is currently mounted.

I have done some research, but can only find info about upgrades from previous versions of SQL like 2008, but about changing from express to standard in the same version.

Looking at the SQL Server Installation Center there is a section under Maintenance called Edition Upgrade. Is this what I need?

I am doing this to clean a mess left by my predecessor. I inherited this system and am trying to get it off express.

9

1 Answer

I am posting this as the answer only because @Ramhound has not done so. If he wants the points he can post and I'll change the accepted answer.

What I ended up doing was following this post as it walks through changing the edition of SQL 2008 Express to a full version of SQL 2008. Although I am using SQL 2012 the steps were the same.

1. Run the full version of SQL setup application.
2. Select Maintenance > Edition Upgrade
3. Select the SQL instance and start the upgrade.
4. After the upgrade is complete, apply the latest SQL service packs since this upgrade does not include them when transferring from SQL Express

After the upgrade is complete, apply the latest SQL service pack since this upgrade actually does not have on and it is not transferred from SQL Express.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy