Differences

This shows you the differences between two versions of the page.

sqldata_cfg [April 20, 2017 3:43 am]
sqlines
sqldata_cfg [April 20, 2017 4:08 am] (current)
sqlines
Line 11: Line 11:
DDL (schema) migration options. DDL (schema) migration options.
 +==== -ddl_tables ====
 +
 +When //-ddl_tables=yes// the tool executes DDL statements defined by //-topt// command line option (CREATE; DROP and CREATE TABLE, or TRUNCATE TABLE statements). When //no// is specified the tool does not perform any DROP, CREATE, TRUNCATE statements for tables.
 +
 +Default is //yes//.
 +
 +==== -constraints ====
 +
 +When //-constraints=yes// the tool migrates table constrains (primary and unique keys, check constraints, foreign keys).
 +
 +Default is //yes//. It is possible to set //-ddl_tables=no// and //-constraints=yes// to migrate constraints only for existing tables.
 +
 +==== -indexes ====
 +
 +When //-indexes=yes// the tool migrates table indexes. Note that some indexes are defined by constraints (like primary or unique keys) and they will not be migrated by this option.
 +
 +Default is //yes//. It is possible to set //-ddl_tables=no// and //-indexes=yes// to migrate indexes only for existing tables.
===== Data Options ===== ===== Data Options =====