Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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]]