Is there a way to upgrade an instance of SQL Server 2012 Express to SQL Server Evaluation Enterprise?

I tried using the SQL Server Installation Center and clicking Maintenance, and then Edition Upgrade. I selected to upgrade the Express Instance to Evaluation, but I get an error on the Edition Upgrade Rules step, which says "The selected SQL Server instance does not meet upgrade matrix requirements." I also checked out the Supported Version and Upgrade Paths on Supported Version and Edition Upgrades and Express 2012 to Enterprise 2012 is supported, so it would make sense that Express 2012 to Evaluation Enterprise 2012 should be supported especially since they are both free and Express has less features than Enterprise. Am I doing something wrong? Is there a better way to perform this upgrade? Thanks,

  • How many databases on your express install? How much work to backup, install fresh, and restore? – RThomas Mar 21 '13 at 20:32
  • Currrently, around 12 databases on the Express install. All of them are related to a SharePoint 2013 evaluation install. I'm just worried that if I migrate them with a fresh install, I'll get some configuration wrong and SharePoint won't work. – Anne-of-GG Mar 21 '13 at 20:44
  • 1
    Yeah, sharepoint install makes it a little more fragile for sure. – RThomas Mar 21 '13 at 20:47

You can not Upgrade from SQL Server Express Version to SQL Server Evaluation.

See this msdn link for all upgrade path...

Supported Version and Edition Upgrades...

Install them side by side and they you copy wizard to move DB.

  • 1
    Well, it doesn't explicitly say that you can or can't upgrade to the Evaluation version when you have a free express version, but I guess I'll have to take that as a no. – Anne-of-GG Mar 26 '13 at 1:46
  • Unbelievable! I don't think Microsoft ever uses their own products! Instead of doing something intelligent, it just puts up a non-descript error message. I guess it was too expensive or they were trying to save space by not adding a proper error message. – ATL_DEV Oct 25 '18 at 20:39
  • I wonder if this isn't an oversight, but to way to punish the the customer for not buying the standard version. – ATL_DEV Oct 26 '18 at 17:07

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.