Forum Discussion

Copper Contributor

Jan 07, 2022

Solved

compatibility SQL Express VS SQL Standard

Hello. I am currently using SQL Express 2017. The database has grown so much that I have to switch to the standard version. I have several programs connected to the SQL server that work on a...

olafhelper
Jan 07, 2022
KrzysiekBojak , the database engine of Express, Standard, Web, Developer and Enterprise are exactly the same, there are only limitations in the available feature set.
If an app works with Express Edition, then it works with Standard Edition as well, only "better" = faster.

You can see it on Service Packs, you use the same SP installer independent on the installed Edition.

See also Editions and supported features of SQL Server 2019 - SQL Server | Microsoft Docs

olafhelper

Bronze Contributor

Jan 07, 2022

KrzysiekBojak , the database engine of Express, Standard, Web, Developer and Enterprise are exactly the same, there are only limitations in the available feature set.

If an app works with Express Edition, then it works with Standard Edition as well, only "better" = faster.

You can see it on Service Packs, you use the same SP installer independent on the installed Edition.