Export (0) Print
Expand All

User Interface Reference (OracleToSQL)

SQL Server 2012

This section includes Help topics for SQL Server Migration Assistant (SSMA) for Oracle.

The following table lists the SSMA dialog boxes:

Topic

Description

Advanced Object Selection (SSMA Common)

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 (SSMA Common)

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 (SSMA Common)

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) (SSMA Common)

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) (SSMA Common)

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 Global Settings 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 (SSMA Common)

The Save Metadata dialog box appears when you save a project that is missing metadata.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft