Skip to main content

ORACLE TO SQL SERVER DATA MIGRATION

The SQL Server version of the application to be moved is installed on the SQL server before the data is started to be moved. Tables are created. The existing data on the Oracle side will be transferred to the empty tables that are formed.

Steps to migrate data from Oracle to SQL Server with SSMA:​

1.SQL Download and install the SERVER MIGRATION ASSISTANT for ORACLE (SSMA) tool. 2. SSMA is run. 3. The new project is created with New Project.

  1. The new Project is named. The location of the project file is selected and the version of SQL Server to be moved is selected.

  1. Click the Connect to Oracle button and connect to Oracle DB. Example connection string: Data Source =(DESCRIPTION=(ADDRESS=(HOST=xxx.xxx.xx.xx) (PROTOCOL=TCP)(PORT=1521)) (CONNECT_DATA=(SID=xxxx))); password=xxxxx; user id=xxxx; DBA Privilege=SYSDBA;

  1. After connecting to Oracle, the window that opens selects the schemas with the data to be moved.

  1. Click the Connect to SQL Server button. Connects to SQL server by entering SQL Server information.

  1. Oracle Schemas is clicked and the source and target schema is selected on the right side of the open. Such as .dbo on the sql server side.

  1. The migration process is started with the Migrate Data button.