About Ispirer Systems

Ispirer Home Page Database Migration Application Conversion Downloads


Sqlways.ini File - Section [SPLICE_MACHINE]

This article describes sqlways.ini file's [SPLICE_MACHINE] section and options it contains.

Option name Description
HOST This option sets the host name 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 Splice Machine database.
PWD This option sets password that will be used together with the user account to connect to Splice Machine database.
PORT This option sets port number that will be used to connect to Splice Machine 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 (psql.exe) that will be used by SQLWays Wizard tool to perform import into Splice Machine 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 a unique identifier for the row of data in the database and can be used as a unique pointer to the exacted 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”.
TABLESPACE In this option you can specify a tablespace name that will be used in CREATE TABLE statements in Splice Machine.
Default value - Empty.
INDEX_TABLESPACE In this option you can specify a tablespace name that will be used in CREATE INDEX statements in Splice Machine.
Default value - Empty.
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.

Example:

[SPLICE_MACHINE]
HOST=hostname
DATABASE=test
USER=postgres
PORT=4444