.png)
User Interface Reference (OracleToSQL)
This section includes Help topics for SQL Server Migration Assistant (SSMA) for Oracle.
The following table lists the SSMA dialog boxes:
Topic | Description |
Use the Advanced Object Select dialog box to find database objects by using filter criteria, and then select or clear those objects. | |
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. | |
Use the Connect to Oracle dialog box to connect to the Oracle database that you want to migrate. | |
Use the Connect to SQL Server dialog box to connect to the instance of SQL Server to which you want to migrate. | |
Use the Customer Feedback Options dialog box to control if SSMA sends usage data to Microsoft. | |
Displays the results of migrating data from Oracle to SQL Server. | |
Use the Extended Data Migration Settings tab to write custom queries for data migration. | |
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. | |
Use the Editor page of the Global Settings dialog box to configure code editor options. | |
Use the Dialogs page of the Global Settings dialog box to configure default dialog box and warning settings. | |
Use the Logging page of the Global Settings dialog box to configure logging. | |
Use the Global Settings dialog box to set preferences for the SSMA for Oracle user interface. | |
Use the Tester page of the Global Settings dialog box to specify settings for Tester. | |
Use the New Project dialog box to create a new SSMA for Oracle project. | |
Use the Conversion page of the Project Settings dialog box to specify how SSMA for Oracle converts functions and global variables. | |
Use the GUI page of the Project Settings dialog box to specify how much data appears on the Data tab. | |
Use the Migration page of the Project Settings dialog box to customize how SSMA for Oracle migrates data from Oracle to SQL Server. | |
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. | |
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. | |
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. | |
Use the Refresh from Database dialog box to select objects to refresh from the Oracle database. | |
The Save Metadata dialog box appears when you save a project that is missing metadata. |
