Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
sqlways:command-line:sqlways-ini:postgresql-section [November 16, 2018, 11:06:09 AM] – [Sqlways.ini File - Section [Postgre]] darya.prikhodkina | sqlways:command-line:sqlways-ini:postgresql-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
====== Sqlways.ini File - Section [Postgre] ====== | ====== Sqlways.ini File - Section [Postgre] ====== | ||
Line 15: | Line 15: | ||
| **BIN** | Specifies the directory where PSQL.exe utility is located. | | | **BIN** | Specifies the directory where PSQL.exe utility is located. | | ||
| **USE_EXPLICIT_CURSORS** | This option controls the way cursors will be converted in PostgreSQL database. If this option is set to " | | **USE_EXPLICIT_CURSORS** | This option controls the way cursors will be converted in PostgreSQL database. If this option is set to " | ||
- | | **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 is BYTEA, this option will not work for that case. | | + | | **REPLACE_NULL_BYTE_WITH** | In PostgreSQL it is not allowed to insert null byte, except for 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 is BYTEA, this option will not work for that case. \\ For example: REPLACE_NULL_BYTE_WITH=N |
- | | **SET_SEARCH_PATH_TO** | This option will add "SET search_path TO" statement into each sql file generated by the SQLWays Wizard tool. To use this option you need just to specify a schema | + | | **SET_SEARCH_PATH_TO** | This option will add "SET search_path TO" statement into each sql file generated by the SQLWays Wizard tool. To use this option you need just to specify a scheme |
- | | **DATA_LOAD_FORMAT** | This option defines the format the data from MSSQL database will be extracted and loaded into PostgreSQL database. Possible values - " | + | | **DATA_LOAD_FORMAT** | This option defines the format |
| **DOLLAR_QUOTED_PGSQL_MASK** | This option controls dollar quotation in the pgsql. The value specified here will be used instead of " | | **DOLLAR_QUOTED_PGSQL_MASK** | This option controls dollar quotation in the pgsql. The value specified here will be used instead of " | ||
| **MULTIPLE_OUT_REFCURSOR_PARAM** | This option controls the conversion of Oracle multiple OUT refcursor parameters in PostgreSQL. If this option is set to " | | **MULTIPLE_OUT_REFCURSOR_PARAM** | This option controls the conversion of Oracle multiple OUT refcursor parameters in PostgreSQL. If this option is set to " | ||
Line 24: | Line 24: | ||
| **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 " | | **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 " | ||
| **ROWNUM_TO_GENERATE_SERIES** | This option controls how Oracle Rownum function will be converted to PostgreSQL database. If this option is set to " | | **ROWNUM_TO_GENERATE_SERIES** | This option controls how Oracle Rownum function will be converted to PostgreSQL database. If this option is set to " | ||
- | | **CAST_PARAMETERS_IN_CALL** | This option controls whether the parameters in call routine statements should be casted | + | | **CAST_PARAMETERS_IN_CALL** | This option controls whether the parameters in call routine statements should be changed |
| **PARTITION_ENABLE** | This option is available for PostgreSQL version 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, " | | **PARTITION_ENABLE** | This option is available for PostgreSQL version 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, " | ||
- | | **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 | + | | **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 |
| **TABLESPACE** | In this option you can specify the tablespace name that will be used in CREATE TABLE statements in PostgreSQL. \\ Default value - Empty. | | | **TABLESPACE** | In this option you can specify the tablespace name that will be used in CREATE TABLE statements in PostgreSQL. \\ Default value - Empty. | | ||
| **INDEX_TABLESPACE** | In this option you can specify the tablespace name that will be used in CREATE INDEX statements in PostgreSQL. \\ Default value - Empty. | | | **INDEX_TABLESPACE** | In this option you can specify the tablespace name that will be used in CREATE INDEX statements in PostgreSQL. \\ 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 - " | | **USE_SOURCE_TABLESPACE_NAMES** | This option defines whether the original tablespace names will be used in the converted object definitions. \\ Possible values - " | ||
- | | **DATA_MIGRATOR_BIN_DIRECTORY** | This option allows you to specify the path to the folder which contains the ISOFDM.exe tool. Usually the path specification is not required as SQLWays | + | | **DATA_MIGRATOR_BIN_DIRECTORY** | This option allows you to specify the path to the folder which contains the ISOFDM.exe tool. Usually the path specification is not required as SQLWays searches for the BIN directory |
+ | | **OPT_DATA_LOAD_FORMAT** | This option defines the format of data extracted from source database, that will be converted into BYTEA data type and loaded into PostgreSQL database. \\ Possible values - Empty, “HEX”, " | ||
+ | | **RAISERROR_TO_SWP** | This option defines the way of conversion of RAISERROR statements when migrating from Sybase ASA to PostgreSQL. If this option is set to " | ||
+ | | **USE_SSL** | This option defines whether SSL will be used to connect to the target database. If this option is set to " | ||
+ | | **SSL_MODE** | This option defines mode of SSL connection to the target database. This option is taken into account only when option USE_SSL is set to " | ||
+ | | **CLIENT_CERTIFICATE** | This option defines a path to the Client SSL Certificate. This option is taken into account only when option USE_SSL is set to " | ||
+ | | **CLIENT_KEY** | This option defines a path to the Client SSL Key. This option is taken into account only when option USE_SSL is set to " | ||
+ | | **ROOT_CERTIFICATE** | This option defines a path to the Root Certificate. This option is taken into account only when option USE_SSL is set to " | ||
+ | | **RETURN_RESULT_FROM_SP_AND_FN** | This option determines the type of returned parameter of functions and procedures. By default table functions will be converted to a function with RETURN TABLE. Other functions and procedures will be converted to functions with SETOF. If conversion tool was not able to define the data types for result set, REFCURSOR will be used as a returned result. If this option is set to " | ||
+ | | **CONVERT_TBL_PAR** | This option determines how the parameters of table type will be converted in the PostgreSQL. If this option is empty, then table type parameters will be converted to a VARCHAR parameter that will store the table name. The table name will be used instead of the parameter inside the body as well. If this option is set to JSON or JSONB, then table type parameter will be converted to JSON\JSONB data type. The functions that work with JSON\JSONB will be used inside the object as well. This option works only for Microsoft SQL Server to PostgreSQL direction. \\ Possible values - " | ||
+ | | **SELECT_WITHOUT_FROM_TO_RAISE_NOTICE** | This option determines how to convert SELECT statements without FROM clause. If this option is set to " | ||
+ | | **USER_TYPE_TO_BASE_TYPE** | This option determines how to convert user defined types. If this options is set to " | ||
+ | | **RETURN_WITH_SEL_TO_RASIE_NOTICE** | This option defines conversion of objects that returns both result set from a SELECT and RETURN statement. If this option is set to " | ||
+ | | **IDENTITY_OPTIONS** | This option defines conversion of Identity optoins when migrating from Sybase ASE to PostgreSQL. If this option is set to Remove, then identity options START and INCREMENT will be ommited in the target. If this option is set to empty or " | ||
Line 42: | Line 55: | ||
SET_SEARCH_PATH_TO=schema_name | SET_SEARCH_PATH_TO=schema_name | ||
| | ||
- | \\ | + | |
- | [[http:// | + | |
- | [[http:// | + | |
- | [[http:// | + |