You have synchronized the converted objects with the SQL Server database. The Oracle providers are installed on the computer that is running SSMA. Otherwise, from the View menu, select Output.

To view migration messages, make sure that the Output pane is visible. The number of rows loaded into SQL Server in each transaction is configured in the project settings. Migrating data is a bulk-load operation that moves rows of data from Oracle tables into SQL Server tables in transactions. To initiate migration on the server side, select the Server Side Data Migration Engine option in the Project Settings dialog box. For more information on how to install the extension pack, see Installing Server Components on SQL Server It is installed through the extension pack. The Client-Side Data Migration Engine resides inside the SSMA application and is, therefore, not dependent on the availability of the extension pack.ĭuring the Server side data migration, the engine resides on the target database.

In Project Settings, the Client Side Data Migration Engine option is set. To initiate data-migration on the client side, select the Client Side Data Migration Engine option in the Project Settings dialog box. The Migration Engine in the Project Settings dialog box, allows the user to perform the migration process using two types of data migration engines: For more information about the Project Migration Settings, see Project Settings (Migration) (OracleToSQL).

For more information about how to install the extension pack, see Installing Server Components (OracleToSQL) Setting Migration Optionsīefore migrating data to SQL Server, review the project migration options in the Project Settings dialog box.īy using this dialog box you can set options such as migration batch size, table locking, constraint checking, null value handling, and identity value handling. The SQL Server Agent service must also be running. If the engine being used is Server Side Data Migration Engine, then, before you can migrate data, you must install the SSMA for Oracle Extension Pack and the Oracle providers on the computer that is running SSMA.

Oracle extension pack