Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [Postgre]

This article describes sqlways.ini file [Postgre] 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 PostgreSQL database.
PWD This option sets password that will be used together with the user account to connect to PostgreSQL database.
PORT This option sets port number that will be used to connect to PostgreSQL database.
TARGET_VERSION This option sets the version number of the database where import will be done.
USE_EXPLICIT_CURSORS This option controls the way cursors will be converted in PostgreSQL database. If this option is set to “Yes”, explicit cursor declaration will be used. If “No”, implicit cursor declaration will be used.
Possible values: Yes, No.
REPLACE_NULL_BYTE_WITH In PostgreSQL it is not allowed to insert null byte in not BYTEA data type column. So this option controls how the null byte should be changed to make a correct import.
If the data type of the inserted column will be BYTEA, this option will not work for that case.
SET_SEARCH_PATH_TO This option will add “SET search_path TO” statement in each sql file generated by the SQLWays Wizard tool. To use this option you need just to specify a schema name that will be used in SET search_path TO statement.
By default this option is empty.
DATA_LOAD_FORMAT This option defines in what format the data from MSSQL database will be extracted and loaded into PostgreSQL database. Possible values - “HEX” and “OCT”.
DOLLAR_QUOTED_PGSQL_MASK This option controls dollar quotation in the pgsql. The value specified here will be used instead of “$$” in Pl/PgSQL, that is set by default.
MULTIPLE_OUT_REFCURSOR_PARAM This option controls the conversion of Oracle multiple OUT refcursor parameters in PostgreSQL. If this option is set to “Yes”, OUT REFCURSOR parameters will be converted into OUT REFCURSOR parameters in PostgreSQL. If “No” then Oracle procedure with OUT REFCURSORs parameters will be converted into a function which returns setof refcursors.
Possible values - “Yes”, “No” or Empty.
Default value - “Yes”.
AUTOUPDATE_TIMESTAMP_COLUMN This option controls the way how TIMESTAMP column is converted from Sybase ASE into PostgreSQL database. If this option is set to “Yes”, then in PostgreSQL 2 triggers will be generated, they will update information in a column. If this option is set to “No”, then it will be a common column of BYTEA data type.
Possible values - “Yes”, “No” or Empty.
Default value - “No” or Empty.
USE_TABLE_FUNCTIONS This option controls how Sybase ASE procedures that return result sets will be converted to PostgreSQL. If this option is set to “Yes”, then procedures will be converted to table functions. If it is set to “No” then such procedures will be converted to functions that return result sets of defined data type.
Possible values - “Yes”, “No” or Empty.
Default value - “No” or Empty.
VIRT_COL_SAVE_TBL_NAME This option works only for Oracle tables with virtual columns that should be converted to PostgreSQL. And it controls naming of the generated tables and views in PostgreSQL. If this option is set to “Yes” then generated tables will have the same names as in Oracle database and SQLWays will add suffix “_VW” to the generated views. If this option is set to “No”, then the suffix “_TBL” will be added to the names of converted tables and generated views will have the same names as Oracle tables with virtual columns.
Possible values - “Yes”, “No” or Empty.
Default value - “No” or Empty.
ROWNUM_TO_GENERATE_SERIES This option controls how Oracle Rownum function will be converted into PostgreSQL database. If this option is set to “Yes” then it will be converted to GENERATE_SERIES. If this option is set to “No”, then Oracle Rownum function will be converted to ROW_NUMBER() with OVER clause in PostgreSQL.
Possible values - “Yes” or Empty, “No”.
Default value - “Yes” or Empty.
CAST_PARAMETERS_IN_CALL This option controls whether the parameters in call routine statements should be casted to the appropriate data types in accordance to the routine signature.
Possible values - “Yes”, “No” or Empty.
Default value - “No” or Empty.
PARTITION_ENABLE This option is managed for PostgreSQL versions 10 and later and controls whether table partitioning should be migrated or no. To allow table partitions conversion, set this option to Yes. If table partitions conversion is not required, “No” value should be specified.
Possible values - “Yes”, “No” or Empty.
Default value - “Yes” or Empty.

Example:

[Postgre]
HOST=hostname
DATABASE=test
USER=postgres
USE_EXPLICIT_CURSORS=Yes
SET_SEARCH_PATH_TO=schema_name


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/postgresql-section.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement