Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:vertica-section [2019/06/11 00:26] 127.0.0.1 external edit |
guides:migration-toolkit:command-line:sqlways-ini:vertica-section [2022/08/19 10:47] alina.svidunovich |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| | **PORT** | Specifies a database server port for Vertica. | | | **PORT** | Specifies a database server port for Vertica. | | ||
| | **BIN** | Specifies the directory where Vertica utilities are located. | | | **BIN** | Specifies the directory where Vertica utilities are located. | | ||
| - | | **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]].| | ||