> For the complete documentation index, see [llms.txt](https://help.security.gallagher.com/knowledge-hub/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.security.gallagher.com/knowledge-hub/products/cc-software/configure/databases-an-overview-of-command-centr/databases-upgrading-sql-express-to-sql.md).

# Upgrade SQL Express to SQL Standard

[Command Centre Databases (SQL)](broken://pages/cCfAltV0RyZ60G9YuhuO) › Upgrading SQL Express to SQL Standard

## This page answers

* How do you upgrade the Command Centre SQL Express instance to SQL Standard?

These are edition upgrades (Express to Standard) using the SQL installer's **Edition Upgrade** maintenance path. For service-pack or version upgrades during a multi-version Command Centre upgrade, see the SQLUpgrade utility on [Databases - Considerations](/knowledge-hub/products/cc-software/configure/databases-an-overview-of-command-centr/databases-considerations.md).

> Before starting, best practice is to always have a backup and a working recovery code.

***

## SQL Express 2019 to SQL Standard 2019

1. Run the SQL 2019 Standard installer and go to **Maintenance**, then choose **Edition Upgrade**.

![SQL 2019 Standard installer Maintenance page with the Edition Upgrade option](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-3f03a317ea2a36e1a1079e29e398d1d3eed9cfda%2FSECHUB-CCS-SQL-UPGRADE19-edition-upgrade-menu.png?alt=media)

2. It auto-populates the product key; click Next.

![SQL installer with the product key auto-populated](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-e0355d3317ebb67036555e22532ff827101cddbf%2FSECHUB-CCS-SQL-UPGRADE19-product-key.png?alt=media)

3. Keep clicking Next until the instance window, then choose the Express Gallagher instance.

![SQL installer Instance Configuration showing the Gallagher Express instance](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-f571358aa56d0af2e522f1ce31d32b118a8288dc%2FSECHUB-CCS-SQL-UPGRADE19-instance-selection.png?alt=media)

![SQL installer instance confirmation screen](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-9490de2a6a886093772692a380271ccf7a99e06d%2FSECHUB-CCS-SQL-UPGRADE19-instance-confirm.png?alt=media)

4. Click **Upgrade**.

![SQL installer Ready to Upgrade screen with the Upgrade button](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-cc542bac3c4d4e59350a3c446ea4efb283a4a8c9%2FSECHUB-CCS-SQL-UPGRADE19-upgrade-button.png?alt=media)

***

## SQL Express 2019 to SQL Standard 2022

1. Run the SQL 2022 Standard installer.

![SQL 2022 Standard installer launch screen](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-4cca5c63a4a47be5e0f13e44579466cad6c115b1%2FSECHUB-CCS-SQL-UPGRADE22-installer-start.png?alt=media)

2. Check the correct licence the site has.

![SQL installer edition / licence check screen](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-93e1695949996e3ae223b9f8f907076249e15693%2FSECHUB-CCS-SQL-UPGRADE22-licence-check.png?alt=media)

3. Keep clicking Next until the instance option, then choose the instance to upgrade.

![SQL installer Instance Configuration](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-5aa90de0cde55a5a479a9dd422a162c028f87cf1%2FSECHUB-CCS-SQL-UPGRADE22-instance-select.png?alt=media)

4. Keep clicking Next until you have the option to upgrade.

![SQL installer Ready to Upgrade summary screen](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-a66590bacf0b204a4a1dcd6941065df2deee55c4%2FSECHUB-CCS-SQL-UPGRADE22-upgrade-ready.png?alt=media)

![SQL installer upgrade in progress](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-aaadd2d73f771caaab577c31a18829177c053488%2FSECHUB-CCS-SQL-UPGRADE22-upgrade-progress.png?alt=media)

![SQL installer upgrade complete confirmation](https://328339335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6bM8WhlBE9BYizPWJaPN%2Fuploads%2Fgit-blob-9bc7ffce8b3231ffbd723bb72eda84994c4a6a9a%2FSECHUB-CCS-SQL-UPGRADE22-upgrade-complete.png?alt=media)

***

🔗 **Related**

* [Databases - Considerations](/knowledge-hub/products/cc-software/configure/databases-an-overview-of-command-centr/databases-considerations.md). Service-pack and version upgrades with the SQLUpgrade utility.
* [Archiving - Database Information](/knowledge-hub/products/cc-software/configure/archiving-and-backups/archiving-database-information.md). Why a site outgrows SQL Express in the first place.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.security.gallagher.com/knowledge-hub/products/cc-software/configure/databases-an-overview-of-command-centr/databases-upgrading-sql-express-to-sql.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.