Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [NEOVIEW]

This article describes sqlways.ini file's [NEOVIEW] section and options it contains.

Option name Description
HOST This option sets a host name where import will be performed.
DATABASE This option sets a database name where import will be performed.
USER This option sets a user account that will be used to connect to NeoView database.
PWD This option sets a password that will be used together with the user account to connect to NeoView database.
PORT This option sets a port number that will be used to connect to NeoView database.
TARGET_VERSION This option sets a version number of the database where import will be performed.
BIN This option sets the path to the native utility that will be used by SQLWays Wizard tool to perform import into the NeoView database.
USE_CONVERT_CHAR_TO_VARCHAR Specifies whether CHAR datatype will be converted to VARCHAR when migrating to Teradata.
CONVERT_CHAR_TO_VARCHAR This option works together with USE_CONVERT_CHAR_TO_VARCHAR and defines the length of CHAR columns started from which all the CHAR columns will be converted to VARCHAR.
RANGE_PART_XML_GEN This option helps you to collect the information about RANGE PARTITIONS while converting to NeoView database. If this option is set to Yes, the range_part_spec.xml file is generated during the conversion. This file can be subsequently used for RANGE PARTITION conversion to NeoView. The default value is No.
CONVERT_MULTILINE_TO_SINGLELINE_COMMENT This option controls the way multi-line comments are converted to NeoView. The default value is No.
DEFAULT_STORAGE This option controls the partitioning mechanism to use while converting to NeoView. The default value is HASH_PARTITION_BY, which means that HASH PARTITION is used by default.

Example:

[NEOVIEW]
HOST=hostname
DATABASE=test
USER=postgres
PORT=4444


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/neoview-section.txt · Last modified: March 29, 2019, 12:22:59 PM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement