Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
guides:migration-toolkit:command-line:sqlways-ini:vertica-section [2019/11/16 11:04] darya.prikhodkina |
guides:migration-toolkit:command-line:sqlways-ini:vertica-section [2022/08/19 10:47] alina.svidunovich |
||
---|---|---|---|
Line 12: | Line 12: | ||
| **CONVERT_MULTILINE_TO_SINGLELINE_COMMENT** | This option controls the way the multi-line comments are converted to Vertica. The default value is "No". | | | **CONVERT_MULTILINE_TO_SINGLELINE_COMMENT** | This option controls the way the multi-line comments are converted to Vertica. The default value is "No". | | ||
| **DEFAULT_STORAGE** | This option controls the partitioning mechanism to use while converting to Vertica. The default value is HASH_PARTITION_BY, which means that HASH PARTITION is used by default. | | | **DEFAULT_STORAGE** | This option controls the partitioning mechanism to use while converting to Vertica. The default value is HASH_PARTITION_BY, which means that HASH PARTITION is used by default. | | ||
+ | | **DISABLE_CONSTRAINTS** | This option defines whether constraints will be disabled or enabled. If the value is "Yes" then the constraints will be disabled. If the value is "No" then the constraints will be enabled. Works for primary key and foreign key constraints. \\ Possible values - “Yes”, "No" or Empty. \\ Default value - "No". [[samples:options-examples #[Usage example]:DISABLE_CONSTRAINTS|Usage example]].| | ||