SQLT-DIFF-OLD(1p) User Contributed Perl Documentation SQLT-DIFF-OLD(1p)
sqlt-diff - find the differences b/w two schemas
For a list of all valid parsers:
To diff two schemas:
sqlt-diff [options] file_name1=parser file_name2=parser
-d|--debug Show debugging info
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
o New tables
Using the Producer class of the target (second) schema, any tables
missing in the first schema will be generated in their entirety
(fields, constraints, indices).
o Missing/altered fields
Any fields missing or altered between the two schemas will be
ALTER TABLE <table_name>
[CHANGE <field_name> <datatype> (<size>)] ;
o Missing/altered indices
Any indices missing or of a different type or on different fields
will be indicated. Indices that should be dropped will be reported
DROP INDEX <index_name> ON <table_name> ;
An index of a different type or on different fields will be
reported as a new index as such:
CREATE [<index_type>] INDEX [<index_name>] ON <table_name>
( <field_name>[,<field_name>] ) ;
"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.
Ken Youens-Clark <firstname.lastname@example.org>.
perl v5.20.2 2014-11-24 SQLT-DIFF-OLD(1p)
Man Pages Copyright Respective Owners. Site Copyright (C) 1994 - 2021
All Rights Reserved.