NAME

sql_translator.pl - convert an SQL database schema

SYNOPSIS

For help:

  ./sql_translator.pl -h|--help

For a list of all parsers and producers:

  ./sql_translator.pl -l|--list

To translate a schema:

  ./sql_translator.pl 
        -f|--from|--parser MySQL 
        -t|--to|--producer Oracle 
        [options] 
        file

  Options:

    -d|--debug                Print debug info
    --trace                   Print parser trace info
    --no-comments             Don't include comments in SQL output
    --show-warnings           Print to STDERR warnings of conflicts, etc.
    --add-drop-table          Add 'drop table' statements before creates
    --xlate=foo/bar,baz/blech Overrides for field translation

DESCRIPTION

This script is part of the SQL Fairy project (http://sqlfairy.sourceforge.net/). It will try to convert any database syntax for which it has a grammar into some other format it knows about.

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

AUTHOR

Ken Y. Clark <kclark@cpan.org>

SEE ALSO

SQL::Translator.