Ispirer Website
Ispirer Capabilities - SAP HANA Migration
Free Trial
Sqlways.ini File - Section [SAPHANA]
This article describes sqlways.ini file [SAPHANA] section and options it contains.
Option name | Description |
---|---|
HOST | This option sets the host name where import will be performed. |
INSTANCE_NUMBER | This option sets the instance number of the server where import will be performed. |
DATABASE | This option sets the database name where import will be performed. |
USER | This option sets user account that will be used to connect to Sap Hana database. |
PWD | This option sets password that will be used together with the user account to connect to Sap Hana database. |
PORT | This option sets port number that will be used to connect to Sap Hana database. |
TARGET_VERSION | This option sets the version number of the database where import will be performed. |
BIN | This option sets the path to the native utility (hdbsql.exe) that will be used by SQLWays Wizard tool to perform an import into the Sap Hana database. |
CHARACTER_SET | This option defines the encoding that will be used to store the extracted data in the files in export folder. |
GENERATE_CDS | This option allows generating CDS files with extension .hdbschema when migrating tables to Sap Hana database. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
CDS_NAMESPACE | This option allows generating the required namespace in CDS files when migrating tables to Sap Hana database. |
COLUMN_STORE_TABLES | This option allows converting tables from source database to COLUMN tables in Sap Hana. Possible values - “Yes”, “No” or Empty. Default value - “No” or Empty. |
APPLIANCE_DIR | A path to the folder where CSV and CTL files will be moved after the conversion process should be specified in this option in order to load the definitions and data into Sap Hana database. |
COMMAND_SEPARATOR | A command separator that will be used in the generated sql files should be specified in this option. A user can specify its own separator. Default value - “#”. |
Example:
[SAPHANA] HOST=hostname DATABASE=test USER=postgres PORT=4444 CHARACTER_SET=UTF8