Last Updated on
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
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.
INSERT INTO dbo.SQLTable1
SELECT * FROM OPENQUERY(ORALINKEDSERV, ‘SELECT * FROM OracleTable1’)
A SQL Procedure can be written using this approach.
- 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.