About Ispirer Systems
Ispirer Home Page Database Migration Application Conversion Downloads
Sqlways.ini File - Section [Greenplum]
This article describes sqlways.ini file's [Greenplum] section and the options it contains.
| Option name | Description |
|---|---|
| HOST | This option sets the host name where import will be done. |
| DATABASE | This option sets the database name where import will be done. |
| USER | This option sets user account that will be used to connect to Greenplum database. |
| PWD | This option sets password that will be used together with the user account to connect to Greenplum database. |
| PORT | This option sets port number that will be used to connect to Greenplum database. |
| TARGET_VERSION | This option sets the version number of the database where import will be done. |
| BIN | Specifies the directory where PSQL.exe utility is located. |
| TABLESPACE | In this option you can specify the tablespace name that will be used in CREATE TABLE statements in Greenplum. Default value - Empty. |
| INDEX_TABLESPACE | In this option you can specify the tablespace name that will be used in CREATE INDEX statements in Greenplum. Default value - Empty. |
| DISTRIBUTED_BY_ON_PK | When this option is set to ‘Yes’ (default value is ‘No’) DISTRIBUTED BY clause will be added to CREATE TABLE statement during conversion. The following rules are applied: 1) If converted table has primary key, DISTRIBUTED BY clause includes all columns that are included in primary key. All UNIQUE INDEXES and UNIQUE constrains are discarded. 2) If converted table has only UNIQUE INDEXES, DISTRIBUTED BY clause is based on the UNIQUE INDEX that has the least number of columns. All other UNIQUE INDEXES and UNIQUE CONSTRAINTS are discarded. 3) If PRIMARY KEY or UNIQUE constraints/indexes have more then 3 columns then will be use DISTRIBUTED RANDOMLY. |
| USE_SOURCE_TABLESPACE_NAMES | This option defines whether the original tablespace names will be used in the converted object definitions. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
| TABLES_WITH_OIDS | This option defines whether the tables will be created with OID. OID column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. By default this option is set to “No”. This means that all the CREATE TABLE statements will be created with the WITH OIDS option. Possible values - “Yes”, “No” or Empty. Default value - “No”. |
| ORA_COMPATIBL_MODULE | If this option is set to “Yes”, some system Oracle functions will not be converted to Greenplum database, as their syntax will be supported by the Oracle Compatible Module, that can be used with Greenplum databases. If this option is set to “No”, all the functions are to be converted to Greenplum. Possible values - “Yes”, “No” or Empty. Default value - “No”. |
Example:
[greenplum] DISTRIBUTED_BY_ON_PK=Yes