User Interface Reference (DB2ToSQL)
This section includes Help topics for SQL Server Migration Assistant (SSMA) for DB2.
In This Section
The following table lists the SSMA dialog boxes:
Topic | Description |
---|---|
Advanced Object Selection (DB2ToSQL) | Use the Advanced Object Select dialog box to find database objects by using filter criteria, and then select or clear those objects. |
Assessment Report (DB2ToSQL) | Use the Assessment Report to view the results of the conversion of DB2 objects to Transact-SQL syntax, and to estimate the time and complexity of a migration to SQL Server. |
Connecting to DB2 Database (DB2ToSQL) | Use the Connect to DB2 dialog box to connect to the DB2 database that you want to migrate. |
Connect to SQL Server (DB2ToSQL) | Use the Connect to SQL Server dialog box to connect to the instance of SQL Server to which you want to migrate. |
Data Migration Report (DB2ToSQL) | Displays the results of migrating data from DB2 to SQL Server. |
Data Migration Settings | Use the Extended Data Migration Settings tab to write custom queries for data migration. |
Edit Type Mapping (DB2ToSQL) | Use the New Type Mapping or Edit Type Mapping dialog boxes to create or modify the mapping of data types between the source and target databases and database objects. |
Global Settings (Editor) (DB2ToSQL) | Use the Editor page of the Global Settings dialog box to configure code editor options. |
Global Settings (Dialogs) (DB2ToSQL) | Use the Dialogs page of the Global Settings dialog box to configure default dialog box and warning settings. |
Global Settings (Logging) (DB2ToSQL) | Use the Logging page of the Global Settings dialog box to configure logging. |
Global Settings (Output Window) (DB2ToSQL) | Use the Global Settings dialog box to set preferences for the SSMA for DB2 user interface. |
New Project (DB2ToSQL) | Use the New Project dialog box to create a new SSMA for DB2 project. |
Project Settings (Conversion) (DB2ToSQL) | Use the Conversion page of the Project Settings dialog box to specify how SSMA for DB2 converts functions and global variables. |
Project Settings (GUI) (DB2ToSQL) | Use the GUI page of the Project Settings dialog box to specify how much data appears on the Data tab. |
Project Settings (Migration) (DB2ToSQL) | Use the Migration page of the Project Settings dialog box to customize how SSMA for DB2 migrates data from DB2 to SQL Server. |
Project Settings(Synchronization) (DB2ToSQL) | Use the Synchronization page of the Project Settings dialog box to customize how SSMA for DB2 creates or alters migrated database objects in SQL Server. |
Project Settings(Loading System objects) (DB2ToSQL) | Use the Loading System Objects page of the Project Settings dialog box to specify which DB2 system objects SSMA converts and loads into SQL Server. |
Project Settings (Type Mapping) (DB2ToSQL) | Use the Type Mapping page of the Project Settings dialog box to specify the default type mappings for all databases and database objects in the SSMA for DB2 project. |
Refresh from Database (DB2ToSQL) | Use the Refresh from Database dialog box to select objects to refresh from the DB2 database. |
Save Metadata (DB2ToSQL) | The Save Metadata dialog box appears when you save a project that is missing metadata. |
See Also
Getting Started with SSMA for DB2 (DB2ToSQL)
Migrating DB2 Databases to SQL Server (DB2ToSQL)