Jess Robinson > SQL-Translator-0.08 > sqlt-diff

Download:
SQL-Translator-0.08.tar.gz

Annotate this POD

CPAN RT

New  58
Open  21
View/Report Bugs
Source   Latest Release: SQL-Translator-0.09005

NAME ^

sqlt-diff - find the differences b/w two schemas

SYNOPSIS ^

For help:

  sqlt-diff -h|--help

For a list of all valid parsers:

  sqlt -l|--list

To diff two schemas:

  sqlt-diff [options] file_name1=parser file_name2=parser

Options:

  -d|--debug   Show debugging info
  -t|--trace   Turn on tracing for Parse::RecDescent
  -c|--case-insensitive   Compare tables/columns case-insenstiviely

DESCRIPTION ^

sqlt-diff is a utility for creating a file of SQL commands necessary to transform the first schema provided to the second. While not yet exhaustive in its ability to mutate the entire schema, it will report the following

"ALTER/DROP TABLE" and "CREATE INDEX" statements are not generated by the Producer, unfortunately, and may require massaging before being passed to your target database.

AUTHOR ^

Ken Y. Clark <kclark@cpan.org>.

SEE ALSO ^

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

syntax highlighting: