How to upgrade from SQL 2008 Express to SQL 2014 Express

Question

Hello,

Can you please guide me on the process.

On the MS SQL 2014 Express download page there are multiple binaries available, which one is right? Advanced Services or With Tools etc.

Thanks in advance

Answer 1

Hi @jbrims ，

Just a little tip:
This doc explains the upgrade steps in detail:
Upgrade to a Different Edition of SQL Server (Setup)

Download SQL Server media, double clicking on SQL Server setup, from the SQL Server Installation Center click Installation, and then click Upgrade from a previous version of SQL Server

By the way, if you think your issue has been resolved, do not forget mark the answer as accepted

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You can use anyone, but why upgrade to a version that is out of mainstream support? Why not upgrade to SQL 2019?

By the way, your SQL 2008 instance is 64-bit, isn't it?

Answer 3

2014 because of application limitations.

yes, 64 bit.

thanks for your answer!

Answer 4

thank you!

i see that there is a separate SQL Express SP3, I will make sure to install it and then the CU4 right after.

thanks again

Answer 5

thanks again!