User Interface Reference (OracleToSQL)
This section includes Help topics for SQL Server Migration Assistant (SSMA) for Oracle.
In This Section
The following table lists the SSMA dialog boxes:
| Topic | Description |
|---|---|
| Advanced Object Selection (OracleToSQL) | Use the Advanced Object Select dialog box to find database objects by using filter criteria, and then select or clear those objects. |
| Assessment Report (OracleToSQL) | Use the Assessment Report to view the results of the conversion of Oracle objects to Transact-SQL syntax, and to estimate the time and complexity of a migration to SQL Server. |
| Connect To Oracle (OracleToSQL) | Use the Connect to Oracle dialog box to connect to the Oracle database that you want to migrate. |
| Connect to SQL Server (OracleToSQL) | 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 (OracleToSQL) | Displays the results of migrating data from Oracle to SQL Server. |
| Data Migration Settings | Use the Extended Data Migration Settings tab to write custom queries for data migration. |
| Edit Type Mapping (OracleToSQL) | 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) (OracleToSQL) | Use the Editor page of the Global Settings dialog box to configure code editor options. |
| Global Settings (Dialogs) (OracleToSQL) | Use the Dialogs page of the Global Settings dialog box to configure default dialog box and warning settings. |
| Global Settings (Logging) (OracleToSQL) | Use the Logging page of the Global Settings dialog box to configure logging. |
| Global Settings (Output Window) (OracleToSQL) | Use the Global Settings dialog box to set preferences for the SSMA for Oracle user interface. |
| Global Settings (Tester) (OracleToSQL) | Use the Tester page of the GlobalSettings dialog box to specify settings for Tester. |
| New Project (OracleToSQL) | Use the New Project dialog box to create a new SSMA for Oracle project. |
| Project Settings (Conversion) (OracleToSQL) | Use the Conversion page of the Project Settings dialog box to specify how SSMA for Oracle converts functions and global variables. |
| Project Settings (GUI) (OracleToSQL) | Use the GUI page of the Project Settings dialog box to specify how much data appears on the Data tab. |
| Project Settings (Migration) (OracleToSQL) | Use the Migration page of the Project Settings dialog box to customize how SSMA for Oracle migrates data from Oracle to SQL Server. |
| Project Settings(Synchronization) (OracleToSQL) | Use the Synchronization page of the Project Settings dialog box to customize how SSMA for Oracle creates or alters migrated database objects in SQL Server. |
| Project Settings(Loading System objects) (OracleToSQL) | Use the Loading System Objects page of the Project Settings dialog box to specify which Oracle system objects SSMA converts and loads into SQL Server. |
| Project Settings (Type Mapping) (OracleToSQL) | 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 Oracle project. |
| Refresh from Database (OracleToSQL) | Use the Refresh from Database dialog box to select objects to refresh from the Oracle database. |
| Save Metadata (OracleToSQL) | The Save Metadata dialog box appears when you save a project that is missing metadata. |
See Also
Getting Started with SSMA for Oracle (OracleToSQL)
Migrating Oracle Databases to SQL Server (OracleToSQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for