sql-docs/docs/ssma/ accessibility/ getting-started-with-sql-server-migration-assistant-for-access-accesstosql. md

Most likely to submit
Beginning with SQL Web server Movement Aide for Accessibility (AccessToSQL) Mounting SSMA Making use of SSMA Metal travelers Gain access to Metal Traveler SQL Web Server or Azure SQL Data Source Metal Traveler Metal Toolbars The job toolbar The movement toolbar Menus Result pane and also Mistake Listing pane See additionally
title summary ms.prod ms.custom ms.date ms.reviewer ms.technology ms.topic helpviewer_keywords ms.assetid writer ms.author supervisor Starting with SQL Web server Movement Aide for Gain Access To (AccessToSQL) Movement Aide (SSMA) for Gain access to permits you to promptly transform Accessibility data source challenge or Azure SQL Data source items, publish the resulting items right into or Azure SQL Data source, as well as move information from Accessibility to or Azure SQL Data Source. You can additionally connect Gain access to tables to [needed [INCLUDEssNoVersion> or Azure SQL Data source tables to make sure that you can remain to utilize your existing Accessibility front-end applications with or Azure SQL Data Source.

This subject presents the setup procedure and also aids to acquaint you with the SSMA interface.

Setting up SSMA

To make use of SSMA, you initially need to set up the SSMA customer program on a computer system that can access both the data sources you wish to move as well as the target circumstances of or Azure SQL Data Source. For setup directions, see Setting up SQL Web server Movement Aide for Accessibility (AccessToSQL).

To begin SSMA, click Begin , indicate All Programs , indicate SQL Web Server Movement Aide for Accessibility , and after that choose SQL Web Server Movement Aide for Accessibility

Utilizing SSMA

After setting up SSMA, it assists to end up being acquainted with the SSMA interface prior to making use of the device to move Accessibility data sources to or Azure SQL Data Source. The SSMA interface, consisting of the metadata travelers, metadata, toolbars, result pane, and also mistake checklist pane are displayed in the complying with layout:

*

To begin a movement, develop a brand-new task, and after that include Gain access to data sources to Accessibility Metal Traveler. You can then right-click items in Accessibility Metal Traveler to execute jobs such as:

You can additionally execute these jobs by utilizing the food selections and also toolbars.

You need to additionally link to a circumstances of After an effective link, a power structure of data sources shows up in Metal Traveler. After you transform Accessibility schemas to schemas, you can choose those transformed schemas in Metal Traveler, and afterwards fill the schemas right into

You should attach to Azure SQL Data Source if you have actually picked Azure SQL Data source from the Migrate to dropdown in brand-new job dialog box. After an effective link, a power structure of Azure SQL Data source data sources shows up in Azure SQL Data Source Metal Traveler. After you transform Accessibility schemas to Azure SQL Data source schemas, you can pick those transformed schemas in Azure SQL Data Source Metal Traveler, and afterwards fill the schemas right into

After you fill transformed schemas right into or Azure SQL Data source, you can go back to Accessibility Metal Traveler and also move information from Accessibility data sources right into or Azure SQL Data source data sources. You can likewise connect Accessibility tables to [required [INCLUDEssNoVersion> or Azure SQL Data source tables.

To learn more regarding these jobs as well as just how to execute them, see the adhering to subjects:

The complying with areas explain the attributes of the SSMA interface.

Metal travelers

SSMA has 2 metadata travelers that you can make use of to search as well as execute activities on Gain access to as well as or Azure SQL Data source data sources.

Gain Access To Metal ExplorerAccess Metal Traveler reveals info regarding the Accessibility data sources that have actually been contributed to the task. When you include a Gain access to data source, SSMA obtains metadata regarding that data source, which is the metadata that is readily available in Accessibility Metal Traveler.

You can make use of Gain access to Metal Traveler to do the adhering to jobs:

Search the tables in each Gain access to data source.

SQL Web Server or Azure SQL Data Source Metal Traveler or Azure SQL Data source Metal Traveler reveals details concerning a circumstances of or Azure SQL Data Source. When you attach to a circumstances of or Azure SQL Data source, SSMA obtains metadata regarding that circumstances as well as shops it in the job data.

You can make use of the SQL Web server or Azure SQL Data Source Metal Traveler to choose modified Accessibility data source things and also tons (synchronize) those items right into the circumstances of or Azure SQL Data Source.

For more details, see Loading Converted Data source Furnishings right into SQL Web Server.

Metal

To the right of each metadata traveler are tabs that explain the picked item. As an example, if you choose a table in Gain access to Metal Traveler, 4 tabs show up: Table , Kind Mapping , Residence , as well as Information , if you choose a table in Metal Traveler, 3 tabs show up: Table , SQL , and also Information

The majority of metadata setups are read-only. Nonetheless, you can change the complying with metadata:

In Gain Access To Metal Traveler, you can change kind mappings. Make certain to make these modifications prior to you develop records or transform schemas.

Toolbars

SSMA has 2 toolbars: a task toolbar as well as a movement toolbar.

The job toolbarThe task toolbar consists of switches for dealing with tasks, including Gain access to data source documents, and also attaching to or Azure SQL Data Source. These switches appear like the commands on the Submit food selection.

The movement toolbarThe movement toolbar includes the adhering to commands:


Begin making use of SSMA to transform Gain access to data source challenge SQL Web server or Azure SQL Data source items, submit the resulting items, and also move information.
ButtonFunction
Transform, Tons, as well as Move Transforms Gain access to data sources, lots the modified things right into or Azure SQL Data source, as well as moves information right into or Azure SQL Data Source, done in one action.
Produce Record Transforms the chosen Accessibility schema to or Azure SQL Data source phrase structure, and afterwards develops a record that demonstrates how effective the conversion was.This command is offered just when items are picked in Accessibility Metal Traveler.
Transform Schema Transforms the chosen Accessibility schema to When items are chosen in Accessibility Metal Traveler, or Azure SQL Data source schemas.This command is readily available just.
Migrate Information Migrates information from the Accessibility data source to or Azure SQL Data Source. Prior to you run this command, you should transform the Accessibility schemas to or Azure SQL Data source schemas, and after that pack the items right into When things are picked in Accessibility Metal Traveler, or Azure SQL Database.This command is readily available just.
Quit Quits the present procedure, such as transforming challenge or Azure SQL Data source phrase structure.

Menus

SSMA consists of the complying with food selections:

MenuDescription
Submit Consists of commands for the Movement Wizard, collaborating with tasks, eliminating and also including Accessibility data source data, and also attaching to or Azure SQL Data Source.
Modify Includes commands for searching for and also dealing with message in the information web pages, such as duplicating from the SQL information pane. To open up the Handle Bookmarks dialog, on the Edit food selection, click Manage Bookmarks. In the dialog, you will certainly see a listing of existing book markings. You can make use of the switches on the appropriate side of the dialog to take care of the book marks.
Sight Includes the Integrate Metal Explorers command. This integrates the things in between Accessibility Metal Traveler as well as or Azure SQL Data Source Metal Traveler. Additionally includes commands to show and also conceal the Outcome and also Mistake Checklist panes as well as a choice Layouts to take care of with the Layouts.
Devices Has commands to develop records, export information, move information as well as things, web link tables, as well as offers accessibility to worldwide and also job setups dialog boxes.
Aid Supplies accessibility to SSMA Assistance as well as to the Regarding dialog box.

Outcome pane and also Mistake Listing pane

The Sight food selection supplies commands to toggle the exposure of the Result pane and also the Mistake Checklist pane:

The Outcome pane reveals condition messages from SSMA throughout things conversion, item synchronization, and also information movement.

The Mistake Listing pane reveals mistake, caution, and also educational messages in a checklist that you can arrange.