Skip to content

Latest commit

 

History

History
60 lines (44 loc) · 4.17 KB

migrating-access-databases-to-sql-server-azure-sql-db-accesstosql.md

File metadata and controls

60 lines (44 loc) · 4.17 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection ms.custom f1_keywords helpviewer_keywords
Migrate Access Databases to SQL Server - Azure SQL Database
Use this recommended process to migrate Access databases to SQL Server or Azure SQL Database using SQL Server Migration Assistant (SSMA).
cpichuka
cpichuka
08/15/2017
sql
ssma
upgrade-and-migration-article
sql-migration-content
intro-migration
ssma.access.migratedata.f1
instructions, migration
migrating databases, overview
overview, migration process
procedure, migration
recommended migration process

Migrating Access databases to SQL Server - Azure SQL Database (AccessToSQL)

[!INCLUDEssNoVersion] Migration Assistant (SSMA) is a tool that provides a comprehensive environment that helps you quickly migrate Access databases to [!INCLUDEssNoVersion] or SQL Azure. By using SSMA, you can review Access and [!INCLUDEssNoVersion] or Azure SQL Database objects, assess the Access database for migration, convert Access database objects, load them into [!INCLUDEssNoVersion] or SQL Azure, and then migrate data.

Recommended migration process

To successfully migrate objects and data from Access to [!INCLUDEssNoVersion] or SQL Azure, use the following process:

  1. Create a new SSMA Project. After you create the project, you can set project options, including conversion options, migration options, and data type mappings.

  2. Add Access database files to the project.

    You can add individual files, including files that you find on the computer or network.

  3. Connect to the target instance of SQL Server or Connect to the target instance of SQL Azure.

    You can connect either to SQL Server or SQL Azure.

  4. To customize the mapping between one or more Access databases and [!INCLUDEssNoVersion] or SQL Azure schemas, map the source and target databases.

  5. Optionally, you can create an assessment report to determine whether the Access database objects can be successfully converted to [!INCLUDEssNoVersion] or SQL Azure.

  6. Convert Access database objects to [!INCLUDEssNoVersion] or SQL Azure object definitions.

  7. Load the converted database objects into SQL Server.

    You can load either the database objects into [!INCLUDEssNoVersion] or SQL Azure by using SSMA, or you can save [!INCLUDEtsql] scripts.

  8. Migrate Access data into SQL Server.

    [!NOTE]
    You can convert, load, and migrate schemas and data in one step. To perform one-click migration, click the Convert, Load, and Migrate button.

  9. If you want your Access applications to use the data in [!INCLUDEssNoVersion] or SQL Azure, use link the Access tables to the SQL Server tables.

You can also use the Migration Wizard to guide you through this process. For more information, see Migration Wizard.

See also

Getting Started with SQL Server Migration Assistant for Access
Preparing Access Databases for Migration