1SQLT-DIFF-OLD(1)      User Contributed Perl Documentation     SQLT-DIFF-OLD(1)
2
3
4

NAME

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

SYNOPSIS

9       For help:
10
11         sqlt-diff -h|--help
12
13       For a list of all valid parsers:
14
15         sqlt -l|--list
16
17       To diff two schemas:
18
19         sqlt-diff [options] file_name1=parser file_name2=parser
20
21       Options:
22
23         -d|--debug   Show debugging info
24

DESCRIPTION

26       sqlt-diff is a utility for creating a file of SQL commands necessary to
27       transform the first schema provided to the second.  While not yet
28       exhaustive in its ability to mutate the entire schema, it will report
29       the following
30
31       •   New tables
32
33           Using the Producer class of the target (second) schema, any tables
34           missing in the first schema will be generated in their entirety
35           (fields, constraints, indices).
36
37       •   Missing/altered fields
38
39           Any fields missing or altered between the two schemas will be
40           reported as:
41
42             ALTER TABLE <table_name>
43               [DROP <field_name>]
44               [CHANGE <field_name> <datatype> (<size>)] ;
45
46       •   Missing/altered indices
47
48           Any indices missing or of a different type or on different fields
49           will be indicated.  Indices that should be dropped will be reported
50           as such:
51
52             DROP INDEX <index_name> ON <table_name> ;
53
54           An index of a different type or on different fields will be
55           reported as a new index as such:
56
57             CREATE [<index_type>] INDEX [<index_name>] ON <table_name>
58               ( <field_name>[,<field_name>] ) ;
59
60       "ALTER/DROP TABLE" and "CREATE INDEX" statements are not generated by
61       the Producer, unfortunately, and may require massaging before being
62       passed to your target database.
63

AUTHOR

65       Ken Youens-Clark <kclark@cpan.org>.
66

SEE ALSO

68       SQL::Translator, <http://sqlfairy.sourceforge.net>.
69
70
71
72perl v5.34.1                      2022-05-10                  SQLT-DIFF-OLD(1)
Impressum