Differences
This shows you the differences between two versions of the page.
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 [2023/06/01 23:19] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE] ====== | ||
- | This article describes sqlways.ini file's [VERTICA_ANALYTIC_DATABASE] section and the options it contains. | ||
- | ^ Option name ^ Description ^ | ||
- | | **TARGET_VERSION** | Specifies a target version of Vertica database. | | ||
- | | **HOST** | Specifies a remote host name where the target Vertica database is located. | | ||
- | | **DATABASE** | Specifies a database name that is used in generated scripts for Vertica. | | ||
- | | **USER** | Specifies a user name that is used in generated scripts for Vertica. | | ||
- | | **PWD** | Specifies a user password that is used in generated scripts for Vertica. | | ||
- | | **PORT** | Specifies a database server port for Vertica. | | ||
- | | **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". | | ||
- | | **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. | | ||
- | |||
- | |||
- | |||
- | **Example**: | ||
- | |||
- | [VERTICA_ANALYTIC_DATABASE] | ||
- | HOST=hostname | ||
- | DATABASE=test | ||
- | USER=tester | ||
- | |||
- | \\ | ||
- | ---- | ||
- | === 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]] |