NAME

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
    --trace            Print parser trace info
    --show-warnings    Print warnings to STDERR

  DBI Parser Options:

    --dsn              DSN for connecting to database
    --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 

  DB Producer Options:

    --add-drop-table   Add 'DROP TABLE' statements before creates
    --no-comments      Don't include comments in SQL output

  Diagram Producer Options:

    --imap-file        Filename to put image map data
    --imap-url         URL to use for image map

  HTML/POD Producer Options:

    --pretty           Use CGI::Pretty for the output
    --title            Title of schema

  TTSchema Producer Options:

    --template         The path to the template

  XML-SQLFairy Producer Options:

    --emit-empty-tags  Print empty tags for attributes
    --attrib-values    Use attributes instead of tags for 
                       values of the schema objects

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 Y. Clark <kclark@cpan.org>, darren chamberlain <darren@cpan.org>.

SEE ALSO

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