Others

Which SQL Server Version Does the Access 2019 Upsizing Wizard Use?

Algirdas JasaitisAlgirdas Jasaitis Oct 21, 2026 869 views

Question details

The user needs to know the specific SQL Server version utilized by the Upsizing Wizard in Microsoft Access 2019 when transferring database objects.

Which SQL Server Version Does the Access 2019 Upsizing Wizard Use?
Product
Microsoft Access 2019
Device & OS
not provided
Scenario
Transferring Access database objects and data to a SQL Server environment using the built-in Upsizing Wizard.
Observed behavior
The Upsizing Wizard does not automatically select, install, or default to a single fixed SQL Server version; instead, it requires the user to specify an external SQL Server instance.
Before you start

Before launching the Upsizing Wizard, ensure you have the exact server name, correct authentication credentials, and proper database creation permissions for your target SQL Server environment.

Solution 1Recommended

Specify the Target SQL Server Instance During Upsizing

Use the Upsizing Wizard to manually connect to an existing SQL Server environment, as Access does not restrict you to a built-in SQL Server version.

Microsoft Access 2019’s Upsizing Wizard is designed for maximum flexibility. It does not provide or enforce a specific version of SQL Server. Instead, it securely connects to the SQL Server instance you dictate during the setup phase.

Your database compatibility relies entirely on the SQL Server edition (such as SQL Server 2017, 2019, or SQL Server Express) that you have installed and selected.

1
Launch the Upsizing Wizard

Open your target database in Microsoft Access 2019, navigate to the 'Database Tools' tab on the ribbon, and click 'SQL Server' located in the 'Move Data' group.

2
Select the Upsizing Option

Choose whether you want to create a brand new SQL Server database for your data or link your tables to an existing SQL Server database.

3
Enter Connection Details

Input the specific target SQL Server name, select your preferred authentication method (Windows Authentication or SQL Server Authentication), enter your credentials, and proceed to complete the data migration.

Specify the Target SQL Server Instance During Upsizing
Feature Compatibility Check: Always confirm the target server version and feature compatibility with your database administrator prior to upsizing to prevent data type mismatches.
Free Microsoft Office alternative

Looking for a Lightweight Office Suite Alternative?

While WPS Office does not include a relational database management tool like Microsoft Access, it serves as a highly efficient, free alternative to Microsoft Office for your document, spreadsheet, and presentation tasks. Enjoy a familiar interface and seamless file migration.

  1. 1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and follow the on-screen prompts to set up the software.
  2. 2. Open Your Office Files: Launch WPS Office and open your existing Word, Excel, or PowerPoint files without losing any formatting.
  3. 3. Enjoy Seamless Productivity: Utilize Writer, Spreadsheet, and Presentation tools as an optimized, lightweight alternative to standard Office suites.
Fully compatible with Microsoft Office formats including DOCX, XLSX, and PPTX.Free and lightweight alternative ideal for everyday document management.Familiar tabbed user interface minimizes the learning curve.Built-in PDF editing, conversion, and collaboration tools.
microsoft office alternative - wps office

Frequently Asked Questions

Does Access 2019 automatically install SQL Server Express?

No, Microsoft Access 2019 does not automatically install SQL Server Express or any other SQL Server version. You must download and configure your preferred SQL Server environment independently before utilizing the Upsizing Wizard.

Can I upsize my Access database to an Azure SQL Database?

Yes, the Upsizing Wizard can migrate your Access 2019 tables to an Azure SQL Database. You simply need to provide the Azure server name and administrator credentials during the connection phase of the wizard.

Why is the SQL Server upsizing option grayed out in Access?

The 'SQL Server' upsizing option is often disabled if your database is saved in the older .mdb format. You must upgrade and save your database in the modern .accdb format to enable the Upsizing Wizard feature.