Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:redshift-section [2019/06/11 00:26] 127.0.0.1 external edit |
guides:migration-toolkit:command-line:sqlways-ini:redshift-section [2019/11/16 09:57] darya.prikhodkina |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ====== Sqlways.ini File - Section [Redshift] ====== | ====== Sqlways.ini File - Section [Redshift] ====== | ||
| - | This article describes sqlways.ini file's [Redshift] section and options it contains. | + | This article describes sqlways.ini file's [Redshift] section and the options it contains. |
| ^ Option name ^ Description ^ | ^ Option name ^ Description ^ | ||
| | **HOST** | This option sets the host name where import will be done. | | | **HOST** | This option sets the host name where import will be done. | | ||
| Line 10: | Line 10: | ||
| | **PORT** | This option sets port number that will be used to connect to Amazon Redshift database. | | | **PORT** | This option sets port number that will be used to connect to Amazon Redshift database. | | ||
| | **TARGET_VERSION** | This option sets the version number of the database where import will be done. | | | **TARGET_VERSION** | This option sets the version number of the database where import will be done. | | ||
| - | | **CLOUD_PATH** | This option is required to specify the path on the cloud, where data files will be placed. If value is not set, by default path to the current export folder will be used. | | + | | **CLOUD_PATH** | This option is required to specify the path in the cloud, where data files will be placed. If value isn't set, by default path to the current export folder will be used. | |
| - | | **ACCESS_KEY_ID** | This option sets the access key id that is used to get access to the data files stored on cloud. | | + | | **ACCESS_KEY_ID** | This option sets the access key id that is used to get access to the data files stored in cloud. | |
| - | | **SECRET_ACCESS_KEY** | This option sets the secret access key that is used to get access to the data files stored on cloud. | | + | | **SECRET_ACCESS_KEY** | This option sets the secret access key that is used to get access to the data files stored in cloud. | |
| - | | **BIN** | This option sets the path to the native utility (psql.exe) that will be used by SQLWays Wizard tool to make an import into the Amazon Redshift database. | | + | | **BIN** | This option sets the path to the native utility (psql.exe) that will be used by SQLWays Wizard tool to make import into the Amazon Redshift database. | |
| | **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 "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | | | **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 "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | | ||
| | **TABLESPACE** | In this option you can specify tablespace name that will be used in CREATE TABLE statements in Redshift. \\ Default value - Empty. | | | **TABLESPACE** | In this option you can specify tablespace name that will be used in CREATE TABLE statements in Redshift. \\ Default value - Empty. | | ||