SQL SERVER 2008 Express to 2012 express upgradation

Question

Am using SQLEXPRESS2008 version 10.0.1600.22,now i need to upgrade it into 2012 express edition because it gives 10gb space for each database.How can i upgrade?

Answer 1

Hi

one method would be to apply SQL Server 2008 SP3 http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=27594 and then follow the steps listed in http://msdn.microsoft.com/en-us/library/ms144267.aspx

Answer 2

Hello,

Use Windows Update to apply SP2 or later to SQL Server 2008 first. SP2 for SQL Server 2008 is required to upgrade SQL Server 2012.

Now please download SQL Server 2012 Express, run SQL Server setup, choose Installation on left side of the SQL Server Installation Center, then click on "Upgrade from SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2". This is called an in-place upgrade.

Another option is a side-by-side upgrade. Install a new instance of SQL Server 2012, and then backup databases on the old instance, and then restore the database on the new instance. You can also use detach/attach.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com