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