MySQL Database Conversion Tool

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

  • DB2
  • HSQLDB
  • MS Access
  • MS SQL Server
  • Oracle
  • 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 an Oracle table:

CREATE TABLE TESTUSER.EMPLOYEE ( SSN VARCHAR2(25) NOT NULL, FNAME VARCHAR2(25), MINIT CHAR(1), LNAME VARCHAR2(50), ADDRESS VARCHAR2(50), GENDER CHAR(1), SALARY NUMBER, SUPERSSN VARCHAR2(50), DNO NUMBER, PRIMARY KEY (SSN) )

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

CREATE TABLE EMPLOYEE ( SSN VARCHAR(25) NOT NULL, FNAME VARCHAR(25), MINIT CHAR(1), LNAME VARCHAR(50), ADDRESS VARCHAR(50), GENDER CHAR(1), SALARY DECIMAL, SUPERSSN VARCHAR(50), DNO DECIMAL, PRIMARY KEY (SSN) )

MySQL Database Conversion Tool