SYNOPSIS
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
(see also --use-same-auth below)
--db-user Database user
--db-password Database password
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
/*! comments; default = 30000
MySQL Producer Options:
--mysql-version MySQL server version
General Producer Options
--producer-db-user Database user for producer
--producer-db-pass Database password for producer
--producer-dsn DSN for producer
--use-same-auth Use these DSN, user, password for producer output
DB Producer Options:
--add-drop-table Add 'DROP TABLE' statements before creates
--quote-table-names Quote all table names in statements
--quote-field-names Qjuote 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
HTML/POD Producer Options:
--pretty Use CGI::Pretty for the output
--title Title of schema
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
XML-SQLFairy Producer Options:
--add-prefix Use an explicit namespace prefix of 'sqlf:'
--prefix=<p> Use the namespace prefix given as argument.
--no-newlines Write the XML as a single line.
--indent=<n> Use <n> characters of whitespace to indent the XML.
ClassDBI Producer Options:
--package Base package name for Class::DBI modules.
DESCRIPTION
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.