6 stage to complete migration(SQL Server to Oracle):
Stage 1 : Connect:
1. Download Oracle SQL Developer.
Create new connection Connect to Destination oracle database using system credential using SQL developer
1. Set up a Migration Repository
Enter the following code in the SQL Worksheet to create a user for the migration repository.
CREATE USER MWREP
IDENTIFIED BY mwrep
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO MWREP;
CREATE MATERIALIZED VIEW TO mwrep;
alter user mwrep quota unlimited on USERS;
1. 2. Creating the Migration Repository
Before you create the repository, you need to create a connection to the mwrep user. In the Connections tab, right-click Connections and select New Connection. A New / Select Database Connection window will appear.
1.1.3 Configuring the Third Party Database Connection
You now need to configure a database connection for the database which you would like to migrate. There are two steps to this process:
Download JDBC driver : jtds-1.3.1-dist.zip
Saved : D:\Drivers\jtds-1.3.1-dist
Connect to Third Party Database
Configure 3rd party database connection:
Stage 2 : Capture
Stage 4 : Translate
Create new connection : user : database name of sql and password will be same as user id
