---
title: Upgrading to Microsoft SQL Standard from a 64-bit instance of SQL Express.
description: This article discusses the steps to upgrade to Microsoft SQL Server Standard Edition assuming you're currently on a 64-bit instance of SQL Express (2016 and later.)
---

[Skip to content](https://hub.acctivate.com/articles/upgrade-to-microsoft-sql-server-standard-edition#main-content)

![Acctivate - A CAI Solution](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg)

- [Knowledge Base](https://hub.acctivate.com/articles)

Open main navigation

Close main navigation

- [Knowledge Base](https://hub.acctivate.com/articles)
- [Support Resources / Create Ticket](https://acctivate.com/support)

[Support Resources / Create Ticket](https://acctivate.com/support)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://hub.acctivate.com/articles?hsLang=en)
2. [Database](https://hub.acctivate.com/articles/database?hsLang=en)
3. [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server)

April 11, 2025

# Upgrading to Microsoft SQL Standard from a 64-bit instance of SQL Express.

## This article discusses the steps to upgrade to Microsoft SQL Server Standard Edition assuming you're currently on a 64-bit instance of SQL Express (2016 and later.)

Acctivate includes the free [Microsoft SQL Server Express Edition](https://hub.acctivate.com/articles/4047/?hsLang=en).  You can easily upgrade to SQL Server Standard Edition for increased capacity and performance when necessary.

**Please note:** This article only applies to SQL server instances that are running on 64-bit SQL server. If you are on a 32-bit version of SQL server (SQL 2014 or lower), you will have to create a new instance of SQL server standard and migrate your data over. We have an article about that [here](https://hub.acctivate.com/en/articles/sql-server-setup?hsLang=en).

**Instructions**

Note, different SQL Editions may have different upgrade processes.

1. For newer upgrades to an existing instance, start by using the **SQL Server Installation Center**. Then select **Maintenance** and **Edition Upgrade** to access the Product Key window.  
     1. ![Edition](https://hub.acctivate.com/hs-fs/hubfs/Edition.jpg?width=688&height=519&name=Edition.jpg)
        
        Microsoft SQL Server Edition upgrades are handled through the standard SQL Server installer (setup.exe).
2. The main difference is that you will be required to **enter the product key** for SQL Server Standard Edition.  Choosing the free **Evaluation option is not recommended** since it will expire in 180 days with no warning. 
     1. ![code](https://hub.acctivate.com/hs-fs/hubfs/code.jpg?width=600&height=527&name=code.jpg)
     2. SQL 2022 supports either purchasing a license outright or using Pay-as-you-go billing. Please defer to [Microsoft](https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing#tabxb4d3906242924e30a9ff919c1450a208)for licensing questions and options.
3. You will also want to verify the **Ready to Upgrade** Summary includes **Edition: Standard** and **Action: Upgrade**. (The below screenshot shows Express, but yours should show standard.) 
     1. ![upgrade](https://hub.acctivate.com/hs-fs/hubfs/upgrade.jpg?width=600&height=488&name=upgrade.jpg)
4. Then, click **Upgrade** to start the process.  The Upgrade Process will take a while and **SQL Server will be offline** until the upgrade is **Complete**.

 Note: Microsoft SQL Server licenses must be [purchased from Microsoft](https://www.microsoft.com/en-us/d/sql-server-2019-standard-edition/dg7gmgf0fkx9?activetab=pivot:overviewtab) or a license reseller. Alterity does not sell SQL Server licenses or client access licenses (CALs).

 

- [Getting Started](https://hub.acctivate.com/articles/getting-started?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/getting-started?hsLang=en#basics)
    - [User Interface](https://hub.acctivate.com/articles/getting-started?hsLang=en#user-interface)
    - [Manager windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#manager-windows)
    - [List windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#list-windows)
    - [Transaction windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#transaction-windows)
    - [License and Users](https://hub.acctivate.com/articles/getting-started?hsLang=en#license-and-users)
    - [Email](https://hub.acctivate.com/articles/getting-started?hsLang=en#email)
    - [Getting Help](https://hub.acctivate.com/articles/getting-started?hsLang=en#getting-help)
- [Installation](https://hub.acctivate.com/articles/installation?hsLang=en#main-content)

    - [Acctivate](https://hub.acctivate.com/articles/installation?hsLang=en#acctivate)
    - [Database Server](https://hub.acctivate.com/articles/installation?hsLang=en#database-server)
    - [Mobile WMS Setup](https://hub.acctivate.com/articles/installation?hsLang=en#mobile-wms-setup)
    - [Software Updates](https://hub.acctivate.com/articles/installation?hsLang=en#software-updates)
    - [Email Setup](https://hub.acctivate.com/articles/installation?hsLang=en#email-setup)
    - [Remote Access](https://hub.acctivate.com/articles/installation?hsLang=en#remote-access)
- [Configuration](https://hub.acctivate.com/articles/configuration?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/configuration?hsLang=en#basics)
    - [Users](https://hub.acctivate.com/articles/configuration?hsLang=en#users)
    - [Company Info](https://hub.acctivate.com/articles/configuration?hsLang=en#company-info)
    - [Customers](https://hub.acctivate.com/articles/configuration?hsLang=en#customers)
    - [Sales Orders](https://hub.acctivate.com/articles/configuration?hsLang=en#sales-orders)
    - [Inventory](https://hub.acctivate.com/articles/configuration?hsLang=en#inventory)
    - [Custom Fields](https://hub.acctivate.com/articles/configuration?hsLang=en#custom-fields)
    - [Email Message Templates](https://hub.acctivate.com/articles/configuration?hsLang=en#email-message-templates)
    - [Services](https://hub.acctivate.com/articles/configuration?hsLang=en#services)
- [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en#main-content)

    - [Products](https://hub.acctivate.com/articles/inventory?hsLang=en#products)
    - [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing)
    - [Prices and Units](https://hub.acctivate.com/articles/inventory?hsLang=en#prices-and-units)
    - [Warehouses and Locations](https://hub.acctivate.com/articles/inventory?hsLang=en#warehouses-and-locations)
    - [Lot Numbers](https://hub.acctivate.com/articles/inventory?hsLang=en#lot-numbers)
    - [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager)
    - [Receipts](https://hub.acctivate.com/articles/inventory?hsLang=en#receipts)
    - [Assemblies](https://hub.acctivate.com/articles/inventory?hsLang=en#assemblies)
    - [Kits and Assortments](https://hub.acctivate.com/articles/inventory?hsLang=en#kits-and-assortments)
    - [Landed Cost](https://hub.acctivate.com/articles/inventory?hsLang=en#landed-cost)
    - [Transfers](https://hub.acctivate.com/articles/inventory?hsLang=en#transfers)
    - [Adjustments](https://hub.acctivate.com/articles/inventory?hsLang=en#adjustments)
    - [Counts](https://hub.acctivate.com/articles/inventory?hsLang=en#counts)
    - [Reports](https://hub.acctivate.com/articles/inventory?hsLang=en#reports)
- [Purchasing](https://hub.acctivate.com/articles/purchasing?hsLang=en#main-content)

    - [Purchase Orders](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-orders)
    - [Purchase Order Manager](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-order-manager)
    - [Purchase Invoices](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-invoices)
    - [Vendors](https://hub.acctivate.com/articles/purchasing?hsLang=en#vendors)
- [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#main-content)

    - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#customers)
    - [Locations](https://hub.acctivate.com/articles/customers?hsLang=en#locations)
    - [Credit & Terms](https://hub.acctivate.com/articles/customers?hsLang=en#credit-terms)
    - [Pricing](https://hub.acctivate.com/articles/customers?hsLang=en#pricing)
    - [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email)
- [Sales](https://hub.acctivate.com/articles/sales?hsLang=en#main-content)

    - [Orders](https://hub.acctivate.com/articles/sales?hsLang=en#orders)
    - [Sales Order Manager](https://hub.acctivate.com/articles/sales?hsLang=en#sales-order-manager)
    - [Picking](https://hub.acctivate.com/articles/sales?hsLang=en#picking)
    - [Drop Shipments](https://hub.acctivate.com/articles/sales?hsLang=en#drop-shipments)
    - [Sales Tax](https://hub.acctivate.com/articles/sales?hsLang=en#sales-tax)
    - [Packaging](https://hub.acctivate.com/articles/sales?hsLang=en#packaging)
    - [Shipping](https://hub.acctivate.com/articles/sales?hsLang=en#shipping)
    - [Invoices](https://hub.acctivate.com/articles/sales?hsLang=en#invoices)
    - [Payments](https://hub.acctivate.com/articles/sales?hsLang=en#payments)
    - [Credits](https://hub.acctivate.com/articles/sales?hsLang=en#credits)
- [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#main-content)

    - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-activities)
    - [Business Alerts](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-alerts)
- [QuickBooks](https://hub.acctivate.com/articles/quickbooks?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/quickbooks?hsLang=en#basics)
    - [QuickBooks Online](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-online)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-desktop)
- [Mobile WMS](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#basics)
    - [Picking](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#picking)
    - [Receiving](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#receiving)
    - [Counts](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#counts)
    - [Assemblies](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#assemblies)
- [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#basics)
    - [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options)
- [EDI](https://hub.acctivate.com/articles/edi?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/edi?hsLang=en#basics)
    - [Orders - 850](https://hub.acctivate.com/articles/edi?hsLang=en#orders-850)
    - [Shipments - 856](https://hub.acctivate.com/articles/edi?hsLang=en#shipments-856)
    - [Invoices - 810](https://hub.acctivate.com/articles/edi?hsLang=en#invoices-810)
    - [Warehouse - 940/945](https://hub.acctivate.com/articles/edi?hsLang=en#warehouse-940-945)
- [Reports](https://hub.acctivate.com/articles/reports?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/reports?hsLang=en#basics)
    - [Standard Reports](https://hub.acctivate.com/articles/reports?hsLang=en#standard-reports)
    - [Crystal Reports](https://hub.acctivate.com/articles/reports?hsLang=en#crystal-reports)
    - [Excel](https://hub.acctivate.com/articles/reports?hsLang=en#excel)
- [Database](https://hub.acctivate.com/articles/database?hsLang=en#main-content)

    - [Basics](https://hub.acctivate.com/articles/database?hsLang=en#basics)
    - [Backup & Restore](https://hub.acctivate.com/articles/database?hsLang=en#backup-restore)
    - [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server)
    - [Imports](https://hub.acctivate.com/articles/database?hsLang=en#imports)
- [Troubleshoot](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#main-content)

    - [General](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#general)
    - [Installation](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#installation)
    - [Inventory](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#inventory)
    - [Purchasing](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#purchasing)
    - [Sales](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#sales)
    - [Shipping](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#shipping)
    - [QuickBooks Desktop](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-desktop)
    - [QuickBooks Online](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-online)
    - [Mobile WMS](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#mobile-wms)
    - [Web Store Integration](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#web-store-integration)
    - [EDI](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#edi)
    - [Reports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#reports)
    - [Database](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#database)
    - [Imports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#imports)
    - [Email](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#email)
    - [Integrations](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#integrations)

[![Acctivate Inventory Software](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg "Acctivate Inventory Software")](https://acctivate.com)

Acctivate Knowledge Base

<https://www.twitter.com/acctivate> <https://www.linkedin.com/company/alterity-inc-/> [mailto:support@acctivate.com](mailto:support@acctivate.com)

Copyright © 2025, Alterity, LLC