SQL 2019 Express to Full Upgrade

[Alastairb25]

Hi All,

 

Has anyone come across Instructions for upgrade from SQL Express to Full SQL?

 

We paid for an upgrade by ESS and had bought Full SQL, however at the time it was upgraded with SQL Express

I am taking this up with them

 

However due to DB approaching 10gb we may have to complete an upgrade later today

 

Wondering on approaches, eg New SQL instance and migrate, upgrade existing etc

 

We will be taking copy of VM before hand regardless

 

ESS Support recommended this link

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16

 

 

TIA

Alastair

Edited October 3, 2024 by Alastairb25

[bobsmith]

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16

 

shows there's an upgrade path from SQL 2019 Express to SQL 2022 Full (standard)

 

Taking all the standard precautions of backing stuff up first - the upgrade process is normally straight forward - i.e. run the installer and read it's warnings.

 

Unless changing hardware I've always done in-place upgrades.

[Alastairb25]

Dec 22 Roadmap said 2019 SQL was latest supported, newer roadmap suggests 2022?

 

Thanks

 

 

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16

 

shows there's an upgrade path from SQL 2019 Express to SQL 2022 Full (standard)

 

Taking all the standard precautions of backing stuff up first - the upgrade process is normally straight forward - i.e. run the installer and read it's warnings.

 

Unless changing hardware I've always done in-place upgrades.