Skip to content

getting-started-with-ssma-for-oracle-console-oracletosql.md

Latest commit

 

History

History
65 lines (47 loc) · 3.23 KB

getting-started-with-ssma-for-oracle-console-oracletosql.md

File metadata and controls

65 lines (47 loc) · 3.23 KB
title Getting Started with SSMA for Oracle Console (OracleToSQL)
description Getting Started with SSMA for Oracle Console (OracleToSQL)
author nilabjaball
ms.author niball
ms.date 01/19/2017
ms.service sql
ms.subservice ssma
ms.topic get-started
ms.collection
sql-migration-content
ms.custom
intro-get-started
helpviewer_keywords
Oracle Console, Console Output Conventions
Oracle Console, Launching Console

Getting Started with SSMA for Oracle Console (OracleToSQL)

This section describes the procedure to launch and get started with the Oracle console application. Also listed, herein, are the conventions used in a typical SSMA Console output window.

Launching SSMA Console

Use the following steps to start the SSMA console application:

  1. Go to Start and point to All Programs.

  2. Click the [!INCLUDEssNoVersion] Migration Assistant for Oracle Command Prompt shortcut.

    It displays the SSMA Console usage menu and (/? Help), to help you get started with the console application.

Procedure for Using the SSMA Console

After the console is successfully launched on your Windows system, you could use the following steps to work on it:

  1. Configure SSMA Console through the script files. For more information on this section, see Creating Script Files (OracleToSQL) .

  2. Creating Variable Value Files (OracleToSQL)

  3. Creating the Server Connection Files (OracleToSQL)

  4. Executing the SSMA Console (OracleToSQL) based on your project needs

Additional features:

  1. Specify a password and export/ import it onto other Window machines

  2. Generate Reports to view the detailed xml output reports for assessment /conversion and data migration. Detailed error reports can also be generated for refresh and synchronization commands.

SSMA Console Output Conventions

Upon executing the SSMA script commands and options, the console program displays the results and messages (information, error, etc.) to the user on the console or if required, redirects to an xml output file. Each type of message in the output is signified by a unique color. For example, the text message in white color denotes script file commands; the one in green color represents a prompt for user-input, and so on.

SSMA Console Output_Oracle

Color-interpretation of the console output in the following table:

Color Description
Red Fatal error during execution
Gray Date and Time stamp, message to the user
White Script file commands, message type
Yellow Warning
Green Prompt for user-input
Cyan Start, Finish and Result of an operation

See Also

Installing SSMA for Oracle