Eksportér (0) Udskriv
Udvid alt
EN
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: April 9, 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.

Author: Shaun Tinline-Jones

Before You Begin

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.

Prerequisites

An SSMA is a web download. To download the latest version, see the SQL Server Migration Tools product. As of this writing, the following are the most recent versions:

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.

[Top]

Migrate a Database By Using a SQL Server Migration Assistant

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.

[Top]

Resources

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft