KB Articles

 

KB Article #9045

 

Topic/Category: Migrate data from Oracle DB to SQL server or MariaDB

 

Issue: You have data in an Oracle Database that you would like migrated to an MSSQL Database

 

Solution:

Migrate data from Oracle DB to MSSQL 

 

  • Approach 1: If data type at both the ends are same or compatible.

One can use SQL Server Feature of Linked Servers.

For example:-

INSERT INTO dbo.SQLTable1

SELECT * FROM OPENQUERY(ORALINKEDSERV, ‘SELECT * FROM OracleTable1’)

A SQL Procedure can be written using this approach.

For creating linked servers one can follow links here and here.

 

  • Approach 2: Using tool “Microsoft SQL Server Migration Assistant (SSMA)”

The compete migration steps using SSMA have been explained here.

Using this tool one can migrate any data from oracle to sql server.

 

Migrate data from Oracle DB to MariaDB

One can use MySQL Workbench to migrate most of the db objects and data to MariaDB.

Refer following link Using the MySQL Workbench Migration Wizard for details.

 

 

 

< Back|KB Main Page

Was this article helpful to you?

J.D. Abbey

Comments are closed.