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 [2022/08/19 08:33] alina.svidunovich |
guides:migration-toolkit:command-line:sqlways-ini:vertica-section [2023/06/01 23:19] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ** About Ispirer Systems ** | ||
| + | |||
| + | [[https://www.ispirer.com|Ispirer Home Page]] | ||
| + | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
| + | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
| + | [[https://www.ispirer.com/download|Downloads]] | ||
| + | ---- | ||
| ====== Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE] ====== | ====== Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE] ====== | ||
| Line 12: | Line 19: | ||
| | **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". Usage example| | + | | **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]].| |
| Line 24: | Line 31: | ||
| \\ | \\ | ||
| - | ---- | + | |
| - | === More about Ispirer Systems === | + | |
| - | [[https://www.ispirer.com|Ispirer Home Page]] | + | |
| - | [[https://www.ispirer.com/products/database-migration|Database Migration]] | + | |
| - | [[https://www.ispirer.com/application-conversion|Application Conversion]] | + | |
| - | [[https://www.ispirer.com/download|Downloads]] | + | |