SALG : 1-800-867-1389
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

How to: Use a SQL Server Migration Assistant with Azure SQL Database

Updated: October 16, 2014

There are several SQL Server Migration Assistants that can be used to migrate databases to Microsoft Azure SQL Database from other database products, such as Oracle, MySQL, Sybase, and Microsoft Access.

SQL Server Migration Assistant (SSMA) is a family of products to reduce the cost and risk of migration from Oracle, Sybase, MySQL, and Microsoft Access databases to Microsoft Azure SQL Database or SQL Server. SSMA automates all aspects of migration, including migration assessment analysis, schema and SQL statement conversion, data migration, as well as migration testing.

An SSMA is a web download. To download the latest version, see the SQL Server Migration Tools product.

SSMA is installed by using a Windows Installer-based wizard. SSMA is free, but must be activated by downloading a registration key. After you install and run the application, the application prompts you to register and download the registration key.


The migration process of the SSMA for Access involves the following steps:

  1. Create a new migration wizard. Make sure selecting Azure SQL Database in the Migrate To box.

  2. Add Access databases.

  3. Select the Access objects to migrate.

  4. Connect to Microsoft Azure SQL Database.

  5. Link tables. If you want to use your existing Access applications with Microsoft Azure SQL Database, you can link your original Access tables to the migrated Microsoft Azure SQL Database tables. Linking modifies your Access database so that your queries, forms, reports, and data access pages use the data in the Microsoft Azure SQL Database instead of the data in your Access database.

  6. Convert selected objects.

  7. Load converted objects into Microsoft Azure SQL Database.

  8. Migrate data for selected Access objects.


Syntes du, dette var nyttigt?
(1500 tegn tilbage)
Tak for din feedback
© 2015 Microsoft