DBI Parser Options: sqlt -f|--from|--parser MySQL -t|--to|--producer Oracle [options] file [file2 ...] --dsn DSN for connecting to database (see also --use-same-auth below) --db-user Database user --db-password Database password #### $ sqlt -f DBI-SQLite --db-user "" --db-password "" --dsn dbi:SQLite:temp.sqlite -t SQLite -- -- Created by SQL::Translator::Producer::SQLite -- Created on Thu Oct 2 16:00:34 2014 -- BEGIN TRANSACTION; -- -- Table: "trains" -- CREATE TABLE "trains" ( "A" text NOT NULL, "B" text NOT NULL, "C" real NOT NULL, "D" text NOT NULL, "E" text NOT NULL, "F" real NOT NULL, "G" real NOT NULL ); COMMIT; $ sqlt -f DBI-SQLite --db-user "" --db-password "" --dsn dbi:SQLite:dbidbd.anydata.tsv.temp.sqlite -t Oracle -- -- Created by SQL::Translator::Producer::Oracle -- Created on Thu Oct 2 16:02:17 2014 -- -- -- Table: trains --; CREATE TABLE "trains" ( "A" clob NOT NULL, "B" clob NOT NULL, "C" real NOT NULL, "D" clob NOT NULL, "E" clob NOT NULL, "F" real NOT NULL, "G" real NOT NULL ); / #### $ sqlt -f DBI --dsn dbi:mysql:FOO --db-user guest \ --db-password p4ssw0rd -t PostgreSQL > foo #### $ sqlt -f DBI --db-user "" --db-password "" --dsn dbi:SQLite:dbidbd.anydata.tsv.temp.sqlite -t Oracle -- -- Created by SQL::Translator::Producer::Oracle -- Created on Thu Oct 2 16:07:59 2014 -- -- -- Table: trains --; CREATE TABLE "trains" ( "A" clob NOT NULL, "B" clob NOT NULL, "C" real NOT NULL, "D" clob NOT NULL, "E" clob NOT NULL, "F" real NOT NULL, "G" real NOT NULL ); / $ sqlt -f DBI --db-user "" --db-password "" --dsn dbi:SQLite:dbidbd.anydata.tsv.temp.sqlite -t Sybase -- -- Created by SQL::Translator::Producer::Sybase -- Created on Thu Oct 2 16:08:02 2014 -- -- -- Table: trains -- CREATE TABLE trains ( A varchar(255) NOT NULL, B varchar(255) NOT NULL, C double precision NOT NULL, D varchar(255) NOT NULL, E varchar(255) NOT NULL, F double precision NOT NULL, G double precision NOT NULL ); $ sqlt -f DBI --db-user "" --db-password "" --dsn dbi:SQLite:dbidbd.anydata.tsv.temp.sqlite -t MySQL -- -- Created by SQL::Translator::Producer::MySQL -- Created on Thu Oct 2 16:08:07 2014 -- SET foreign_key_checks=0; -- -- Table: `trains` -- CREATE TABLE `trains` ( `A` text NOT NULL, `B` text NOT NULL, `C` double NOT NULL, `D` text NOT NULL, `E` text NOT NULL, `F` double NOT NULL, `G` double NOT NULL ); SET foreign_key_checks=1;