Upgrading SQL Express Edition 2012 to Standard 2014

Question

Hi there, 

We originally installed our main system database with SQL Express 2012, but now we find that we need to upgrade to Standard. Is it possible to upgrade this in-place or will it involve removing SQL Express and then installing SQL Standard and reconfiguring everything.. 

regards, 

Jonathan.

Answer 1

It is possible to upgrade.

Here is list of all versions of SQL server that is upgradable to SQL 214

http://msdn.microsoft.com/en-us/library/ms143393.aspx

Here are some usefull tips how to:

http://msdn.microsoft.com/en-us/library/cc707783.aspx

---

Mustafa Toroman

Answer 2

Yes it is possible to do an inplace upgrade from SQL 2012 Express to SQL 2014 Standard.

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 3

Thanks for the quick replies guys, I will read through the links now... thanks. 

Answer 4

Yes it is very much possible as Ashwin noted. Just make sure SQL Server 2012 express is at Sp1 before you perform inplace upgrade from SS 2012 express to SS 2014 standard.

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Articles