Upgrade the version from sql server 2012 to 2014

Question

Hi everyone, I use sql server 2012 express on the client machine and now I want to upgrade it to 2014 express. what is the best practice to upgrade it without affecting the existing database Thanks Devendra

Amit Gupta · Answer

Hey Have you tried taking database backup (the .bak file) and then after installing the required sql version, just restore that after upgradation. Do let me know, if you need any clarification.

Jignesh Kumar · Answer

Hi Devendra, Please find below link which will help you, https://dba.stackexchange.com/questions/82403/migrate-sql-server-from-2012-to-2014-11-to-12

Rohit Singh · Answer

If you are looking for a solution to upgrade the version from SQL Server 2012 to 2014, then follow these steps to upgrade MS SQL 2012 to MS SQL 2014. Upgrade from SQL 2012 to SQL 2014 Download the SQL 2014 Express from the http://www.microsoft.com. Select the Installation process and begin the Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012. Continue through the pre-installation process. Pre-request files and services are updated. Setup Support Rules are processed. On the Select Instance screen, select the AutodeskVault instance to upgrade and confirm instance settings. Click Next. Accept the default features on the Select Features screen by clicking Next. On the Instance Configuration screen, click Next. On the Ready to Upgrade screen, click Upgrade. Setup will complete and upgrade the AutodeskVault SQL instance to SQL 2014.

Devendra Kumar · Answer

Okk Amit sir, I will try that. i am just afraid of data should not be lost and a hassle free upgradation

Devendra Kumar · Answer

Thank you both of you for the answer but in my client machine, the version is just 2012 (not any service pack) I tried installing 2014 express sp1 ( as I need to make my application compatible to windows 7), it says you need to have 2012 express sp1 installed to upgrade.( which is more than 600 MB) How can I do hassle free upgradation?

Mageshwaran R · Answer

Hi Kumar, Please refer this link, https://www.youtube.com/watch?v=iknIjtNcZdA