sqlt man page

sqlt — convert SQL schema using SQL::Translator

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.

Author

Ken Youens-Clark <kclark@cpan.org>, darren chamberlain <darren@cpan.org>.

See Also

SQL::Translator, <http://sqlfairy.sourceforge.net>.

Info

2016-05-16 perl v5.24.0 User Contributed Perl Documentation