| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Explore SSMA for Oracle interface |
Learn about the SQL Server Migration Assistant (SSMA) for Oracle installation process, and familiarize yourself with the SSMA user interface. |
cpichuka |
cpichuka |
01/19/2017 |
sql |
ssma |
conceptual |
|
|
[!INCLUDEssNoVersion] Migration Assistant (SSMA) for Oracle lets you quickly convert Oracle database schemas to [!INCLUDEssNoVersion] schemas, upload the resulting schemas into [!INCLUDEssNoVersion] and migrate data from Oracle to [!INCLUDEssNoVersion].
This topic introduces the installation process, and then helps familiarize you with the SSMA user interface.
To use SSMA, you first must install the SSMA client program on a computer that can access both the source Oracle database and the target instance of [!INCLUDEssNoVersion]. You then must install an extension pack and at least one of the Oracle providers (OLE DB or [!INCLUDEvstecado]) on the computer that is running [!INCLUDEssNoVersion]. These components support data migration and the emulation of Oracle system functions. For installation instructions, see Installing SSMA for Oracle (OracleToSQL).
To start SSMA, click Start, point to All Programs, point to [!INCLUDEssNoVersion] Migration Assistant for Oracle, and then click [!INCLUDEssNoVersion] Migration Assistant for Oracle.
After SSMA is installed, you can use SSMA to migrate Oracle databases to [!INCLUDEssNoVersion]. It helps to become familiar with the SSMA user interface before you start. The following diagram shows the user interface for SSMA, including the metadata explorers, metadata, toolbars, output pane, and error list pane:
To start a migration, you must first create a new project. Then, you connect to an Oracle database. After a successful connection, Oracle schemas will appear in Oracle Metadata Explorer. You can then right-click objects in Oracle Metadata Explorer to perform tasks such as create reports that assess conversions to [!INCLUDEssNoVersion]. You can also perform these tasks by using the toolbars and menus.
You must also connect to an instance of [!INCLUDEssNoVersion]. After a successful connection, a hierarchy of [!INCLUDEssNoVersion] databases will appear in [!INCLUDEssNoVersion] Metadata Explorer. After you convert Oracle schemas to [!INCLUDEssNoVersion] schemas, select those converted schemas in [!INCLUDEssNoVersion] Metadata Explorer, and then synchronize the schemas with [!INCLUDEssNoVersion].
After you synchronize converted schemas with [!INCLUDEssNoVersion], you can return to Oracle Metadata Explorer and migrate data from Oracle schemas into [!INCLUDEssNoVersion] databases.
For more information about these tasks and how to perform them, see Migrating Oracle Databases to SQL Server (OracleToSQL).
The following sections describe the features of the SSMA user interface.
SSMA contains two metadata explorers to browse and perform actions on Oracle and [!INCLUDEssNoVersion] databases.
Oracle Metadata Explorer shows information about Oracle schemas. By using Oracle Metadata Explorer, you can perform the following tasks:
-
Browse the objects in each schema.
-
Select objects for conversion, and then convert the objects to [!INCLUDEssNoVersion] syntax. For more information, see Converting Oracle Schemas (OracleToSQL).
-
Select tables for data migration, and then migrate the data from those tables to [!INCLUDEssNoVersion]. For more information, see Migrating Oracle Data into SQL Server (OracleToSQL).
[!INCLUDEssNoVersion] Metadata Explorer shows information about an instance of [!INCLUDEssNoVersion]. When you connect to an instance of [!INCLUDEssNoVersion], SSMA retrieves metadata about that instance and stores it in the project file.
You can use [!INCLUDEssNoVersion] Metadata Explorer to select converted Oracle database objects, and then synchronize those objects with the instance of [!INCLUDEssNoVersion].
For more information, see Loading Converted Database Objects into SQL Server (OracleToSQL).
To the right of each metadata explorer are tabs that describe the selected object. For example, if you select a table in Oracle Metadata Explorer, six tabs will appear: Table, SQL, Type Mapping,Report, Properties, and Data. The Report tab contains information only after you create a report that contains the selected object. If you select a table in [!INCLUDEssNoVersion] Metadata Explorer, three tabs will appear: Table, SQL, and Data.
Most metadata settings are read-only. However, you can alter the following metadata:
-
In Oracle Metadata Explorer, you can alter procedures and type mappings. To convert the altered procedures and type mappings, make changes before you convert schemas.
-
In [!INCLUDEssNoVersion] Metadata Explorer, you can alter the [!INCLUDEtsql] for stored procedures. To see these changes in [!INCLUDEssNoVersion], make these changes before you load the schemas into [!INCLUDEssNoVersion].
Changes made in a metadata explorer are reflected in the project metadata, not in the source or target databases.
SSMA has two toolbars: a project toolbar and a migration toolbar.
The project toolbar contains buttons for working with projects, connecting to Oracle, and connecting to [!INCLUDEssNoVersion]. These buttons resemble the commands on the File menu.
The following table shows the migration toolbar commands:
| Button | Function |
|---|---|
| Create Report | Converts the selected Oracle objects to [!INCLUDEssNoVersion] syntax, and then creates a report that shows how successful the conversion was. This command is disabled unless objects are selected in Oracle Metadata Explorer. |
| Convert Schema | Converts the selected Oracle objects to [!INCLUDEssNoVersion] objects. This command is disabled unless objects are selected in Oracle Metadata Explorer. |
| Migrate Data | Migrates data from the Oracle database to [!INCLUDEssNoVersion]. Before you run this command, you must convert the Oracle schemas to [!INCLUDEssNoVersion] schemas, and then load the objects into [!INCLUDEssNoVersion]. This command is disabled unless objects are selected in Oracle Metadata Explorer. |
| Stop | Stops the current process. |
The following table shows the SSMA menus.
| Menu | Description |
|---|---|
| File | Contains commands for working with projects, connecting to Oracle, and connecting to [!INCLUDEssNoVersion]. |
| Edit | Contains commands for finding and working with text in the details pages, such as copying [!INCLUDEtsql] from the SQL details pane. Also contains the Manage Bookmarks option, where you will be able to see a list of existing bookmarks. You can use the buttons on the right side of the dialog to manage the bookmarks. |
| View | Contains the Synchronize Metadata Explorers command. That synchronizes the objects between Oracle Metadata Explorer and [!INCLUDEssNoVersion] Metadata Explorer. Also contains commands to show and hide the Output and Error List panes and an option Layouts to manage the Layouts. |
| Tools | Contains commands to create reports, and migrate objects and data. Also provides access to the Global Settings and Project Settings dialog boxes. |
| Tester | Contains commands for creating and working with test cases, repository, and backup management system. |
| Help | Provides access to SSMA Help and to the About dialog box. |
The View menu provides commands to toggle the visibility of the Output pane and the Error List pane:
-
The output pane shows status messages from SSMA during object conversion, object synchronization, and data migration.
-
The Error List pane shows error, warning, and informational messages in a sortable list.
Migrating Oracle Data into SQL Server (OracleToSQL)
User Interface Reference (OracleToSQL)