SQLite Database Conversion Tool

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

  • DB2
  • HSQLDB
  • MS Access
  • MS SQL Server
  • MySQL
  • Oracle
  • PostgreSQL

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.DEMO_CUSTOMERS ( CUSTOMER_ID NUMBER NOT NULL, CUST_FIRST_NAME VARCHAR2(20) NOT NULL, CUST_LAST_NAME VARCHAR2(20) NOT NULL, CUST_STREET_ADDRESS1 VARCHAR2(60), CUST_STREET_ADDRESS2 VARCHAR2(60), CUST_CITY VARCHAR2(30), CUST_STATE VARCHAR2(2), CUST_POSTAL_CODE VARCHAR2(10), PHONE_NUMBER1 VARCHAR2(25), PHONE_NUMBER2 VARCHAR2(25), CREDIT_LIMIT NUMBER(9,2), CUST_EMAIL VARCHAR2(30), PRIMARY KEY (CUSTOMER_ID) )

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

CREATE TABLE DEMO_CUSTOMERS ( CUSTOMER_ID DECIMAL NOT NULL, CUST_FIRST_NAME VARCHAR(20) NOT NULL, CUST_LAST_NAME VARCHAR(20) NOT NULL, CUST_STREET_ADDRESS1 VARCHAR(60), CUST_STREET_ADDRESS2 VARCHAR(60), CUST_CITY VARCHAR(30), CUST_STATE VARCHAR(2), CUST_POSTAL_CODE VARCHAR(10), PHONE_NUMBER1 VARCHAR(25), PHONE_NUMBER2 VARCHAR(25), CREDIT_LIMIT DECIMAL(9,2), CUST_EMAIL VARCHAR(30), PRIMARY KEY (CUSTOMER_ID) )

SQLite Database Conversion Tool