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 [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 10: | Line 17: | ||
| **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]].| | ||
Line 23: | 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]] | + |