From Access

In this guide, you learn how to migrate your Microsoft Access databases to SQL Server by using

Migration Assistant for Access (SSMA for Access).

For other migration guides, see

Azure Database Migration Guides.

Before you begin migrating your Access database to SQL Server:

Verify that your source environment is supported.

Get

SSMA for Access.

Get connectivity and sufficient permissions to access both the source and target.

After you meet the prerequisites, you’re ready to discover the topology of your environment

and assess the feasibility of your migration.

By using SSMA for Access, you can review database objects and data and assess databases for

migration. To learn more about the tool, see

Migration Assistant for Access

(AccessToSQL).

To create an assessment:

1. Open

SSMA for Access.

2. Select

, and then select.

3. Enter a project name and a location to save your project. Then select a SQL Server

migration target from the dropdown list, and select.