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
  -v|--validate         Validate the schema
  --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

xSV 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 

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.