Microsoft SQL Server Migration Assistant for Oracle is a tool to automate migration from Oracle database to SQL Server. It consists of a client application that you use to perform a migration from Oracle to SQL Server. It also contains an extension pack that supports data migration and the use of Oracle system functions in your migrated databases.

You install the client application on the computer from which you will perform the migration steps. You must install the extension pack files on the computer where the migrated databases will be hosted. That computer must be running SQL Server.

Command Line Usage: SSMAforOracleConsole.exe
-s|script scriptfile
(required, XML file containing SSMA commands to be executed)
[-v|variable variablevaluefile]
(XML file containing values of parameter variables defined in the scriptfile)
[-c|serverconnection serverconnectionfile]
(XML file containing connection information for servers involved in the migration project)
[-l|log logfile]
(log file for logging SSMA activities)
[-e|projectenvironment projectenvironmentfolder]
(custom project environment settings folder)
[-x|xmloutput [xmloutputfile]]
(console output in XML format, if not specified output by default is in 'plain text' format)
[-p|-securePassword add|remove|list|import|export]
(password management, must be the only option in command line, type -p -? for more options)
[-?](show syntax summary)

Requirements for the SSMA for Oracle client:
1. Microsoft Windows Installer 3.1 or a later version.
2. The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
3. Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
4. Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.

Requirements for the SSMA for Oracle Extension Pack: SQL Server 2005 or higher.
1. Microsoft Windows Installer 3.1 or a later version.
2. Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.

The license of this software is Freeware, you can free download and free use this database management software.