About Ispirer Systems
Ispirer Home Page Database Migration Application Conversion Downloads
Sqlways.ini File - Section [NEOVIEW]
This article describes sqlways.ini file's [NEOVIEW] section and the 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