Oracle Database Conversion Tool

The Oracle database conversion tool contained within RazorSQL allows users to convert Oracle tables to and create Oracle tables from the following database types:

  • DB2
  • MS Access
  • MS SQL Server
  • MySQL
  • PostgreSQL
  • SQLite

RazorSQL contains conversion tools to convert one or many tables at a time. When converting tables, the tool looks at the type of database the table is being converted to, and generates the database specific DDL to generate the table. It looks at the source database column types and does any adjustments necessary to convert those column types to the destination database's format. The tool then generates and executes the insert statements necessary to populate the table data on the destination database.

The following is an example of the DDL for a MS SQL Server table:

CREATE TABLE sample.dbo.project ( pnumber int NOT NULL, pname varchar(50), plocation varchar(50), dnum int, PRIMARY KEY (pnumber) );

When converting the above MS SQL Server table from SQL Server to Oracle, the conversion tool generates the following Oracle DDL corresponding to the above SQL Server DDL:

CREATE TABLE project ( pnumber NUMBER(10) NOT NULL, pname VARCHAR2(50), plocation VARCHAR2(50), dnum NUMBER(10), PRIMARY KEY (pnumber) );

Oracle Database Conversion Tool