Sunday, September 18, 2016

Oracle installation and Migration to MS SQL Server

This is a short blog post about how you can involve in migrating a Oracle based database to SQL Server.

Firstly make sure you have the both latest versions of SQL Server and Oracle.

Oracle -

SQL Server -

Sometimes installing oracle may be a bit difficult task for you as beginner. So let see how to do it quickly .

First you run the setup and wait for the installation window

After a while you get the setup.So it is time to follow the steps ,
In the first view you can enter email and continue the setup

Then you have a selection of installations. Better to select the first option.

Then they ask you whether the configurations for the desktop environment or a server.Surely select the desktop class and continue it.

Then it is time to create a new user for the oracle database home user.So i recommend you to create a new windows user by selecting the second option.This enables a separate user to work with the oracle.

Then the configurations with settings the paths and global name.

Next is the installation process starts and after the setup completion you get the software installed.

If all the things are successfully completed , then type dbca in the command prompt to create a new database for oracle.Here you can manage the database instances as usually .

Let's create a new database

Next is the prerequisite checks

Then you get a summary before creating the database instance

Finally you are creating the database and ready for the migration .

After that you can insert data by creating the tables .So I will not going to do that, I will continue with the database migration tool.

If you need to manipulate the databases and tables you can download SQL Developer tool and continue the work.

There is a tool called SQL Server Migration Assistance for Oracle -

After the installation you get a icon like below

Open the software and you can see a interface as below

So next is the connecting both oracle and SQL Server to this migration tool by giving each servers credentials. You can do it by clicking Connect to oracle and connect to MSSQL Server buttons in left top corner.

After establishing the connection ,you can access to both databases at once and then select the database you need to migrate and click the button Migrate data or convert schema .You can select some option to be compatible with the data types and other fields information.

So that is the end of this short post and hope you will understand the instructions. Cheers .