Sqlways.ini File - Section [VERTICA_ANALYTIC_DATABASE]

This article describes sqlways.ini file [VERTICA_ANALYTIC_DATABASE] section and the options it contains.

Option name	Description
TARGET_VERSION	Specifies the target version for the Vetica database.
HOST	Specifies a remote host name where the target Vetica database is located.
DATABASE	Specifies the database name that is used in generated scripts for Vetica.
USER	Specifies the user name that is used in generated scripts for Vetica.
PWD	Specifies the user password that is used in generated scripts for Vetica.
PORT	Specifies the database server port for Vetica.
BIN	Specifies the directory where Vetica utilities are located.
CONVERT_MULTILINE_TO_SINGLELINE_COMMENT	This option controls the way the multi-line comments are converted to Vetica. The default value is No.
DEFAULT_STORAGE	This option controls the partitioning mechanism to use while converting to Vetica. 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