Notiz
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Iech unzemellen oder Verzeechnesser ze änneren.
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Verzeechnesser ze änneren.
You can set project-level options for each SQL Server Migration Assistant (SSMA) project. These options specify how objects are converted, how data is migrated, and how source data types map to target data types. Before you convert objects to SQL Server or Azure SQL or migrate data into SQL Server or Azure SQL, verify that the configuration options are appropriate for the project.
Configuration options and modes
SSMA has four sets of configuration settings and four modes for configuring these settings: Default, Optimistic, Full, and Custom. The Default mode is recommended for most users. Use the Optimistic mode for simple conversions. Use the Full mode if you want to see all messages. In the Custom mode, you set the options.
The User interface reference describes the settings. For more information about the settings and how the settings are applied in each mode, see:
- Project Settings (Conversion)
- Project Settings (Migration)
- Project Settings (GUI)
- Project Settings (Type Mapping)
- Project Settings (Azure SQL)
Set project options
You can configure default settings for all projects in SSMA. These settings are saved to the SSMA configuration file and applied to any new project that you create.
On the Tools menu, select Default Project Settings.
In the Default Project Settings dialog box, complete one of the following steps:
Select the migration project type from the Migration Target Version dropdown list. To view or change settings, select General at the bottom of the left pane, and then select Conversion, Migration, or Azure SQL.
Note
The Azure SQL option is available in the General tab only if the project type is Azure SQL.
To select a predefined mode, select Default, Optimistic, or Full in the Mode dropdown list.
To specify a custom mode, select Custom in the Mode box. Select an option in the left pane, select the setting or value in the right pane, and then select or enter the new setting or value.
Select OK to save the settings.
You can also customize settings for the current project. SSMA saves these settings to the current project file.
On the Tools menu, select Project Settings.
In the Project Settings dialog box, complete one of the following steps:
To select a predefined mode, select Default, Optimistic, or Full in the Mode dropdown list.
To specify a custom mode, select Custom in the Mode box. Select an option in the left pane, select the setting or value in the right pane, and then select or enter the new setting or value.
Select OK to save the settings.