sqlt1p
Convert sql schema using sql::translator
Usage
For help:
sqlt {-h | --help}
For a
list
of
all
parsers
and
producers:
sqlt {-l | --list}
To translate
a
schema:
sqlt {-f | --from | --parser
MySQL
-t | --to | --producer
Oracle
[options]}
file [file2 ...]
General {Options:
-d | --debug
Print
debug
info
-v | --validate
Validate
the
schema
--version
Show
the
version
of
SQL::Translator
--trace
Print
parser
trace
info
--show-warnings
Print
warnings
to
STDERR}
General Parser
Options:
--skip
Comma-separated
list
of
tables
to
skip
(only
implemented
in
some
parsers)
--ignore_opts
Comma-separated
list
of
table
options
to
ignore
DBI Parser
Options:
--dsn
DSN
for
connecting
to
database
xSV Parser
Options:
--fs
The
field
separator
--rs
The
record
separator
--no-trim
Don't
trim
whitespace
on
fields
--no-scan
Don't
scan
fields
for
data
types
and
sizes
MySQL Parser
Options:
--mysql-parser-version
Target
MySQL
parser
version
for
dealing
with
MySQL Producer
Options:
--mysql-version
MySQL
server
version
DB Producer
Options:
--add-drop-table
Add
'DROP
TABLE'
statements
before
creates
--quote-table-names
Quote
all
table
names
in
statements
--quote-field-names
Quote
all
field
names
in
statements
--no-comments
Don't
include
comments
in
SQL
output
PostgreSQL Producer
Options:
--postgres-version
PostgreSQL
server
version
Diagram Producer
Options:
--imap-file
Filename
to
put
image
map
data
--imap-url
URL
to
use
for
image
map
Dumper Producer
Options:
--skip
Comma-separated
list
of
tables
to
skip
--skiplike
Regex
for
tables
to
skip
--add-truncate
Add
"TRUNCATE
TABLE"
statements
for
each
table
TTSchema Producer
Options:
--template
The
path
to
the
template
--tt-var
var=value
Pass
extra
variables
to
the
template
--tt-conf
option=value
Pass
extra
config
options
to
Template
Overview
This script is part of the SQL Fairy project. It will try to convert any source file for which it has a grammar into any format for which it has a producer.
If using "show-warnings," be sure to redirect STDERR to a separate file. In bash, you could do this:
$ sql_translator.pl -f MySQL -t PostgreSQL --show-warnings \file.sql 1>out 2>err
You can specify a parser or producer located in any module that Perl knows about, allowing you to easily substitute your own.
Releases
10 releases since Debian 4.0 (Etch); the text changed 9 times.