Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:postgresql-section [November 16, 2018, 11:06:09 AM]
darya.prikhodkina [Sqlways.ini File - Section [Postgre]]
sqlways:command-line:sqlways-ini:postgresql-section [June 12, 2020, 10:02:03 AM] (current)
alexandr.kirpichny
Line 31: Line 31:
 | **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. | | **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. |
 | **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 automatically searches for the BIN directory. If the text-box is empty, first it will search for the PATH variable, then it will search the registry. If it fails to find the path to the ISOFDM.exe, no path will be added to the command and system may return the error on the command execution. \\ Default value - Empty. | | **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 automatically searches for the BIN directory. If the text-box is empty, first it will search for the PATH variable, then it will search the registry. If it fails to find the path to the ISOFDM.exe, no path will be added to the command and system may return the error on the command execution. \\ Default value - Empty. |
 +| **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”, "ESCAPE". \\ Default value - Empty. |
 +| **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 "Yes", then RAISERROR statements will be converted into user defined SWP_RAISERROR procedures in PostgreSQL. Definition if this procedure will be generated by Ispirer SQLWays tool automatically. If this option is set to "No", then it will be converted to RAISE EXCEPCION statements. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 +| **USE_SSL** | This option defines whether SSL will be used to connect to the target database. If this option is set to "Yes", then the tool will generate command line that will use information from the SSL options (SSL_MODE, CLIENT_CERTIFICATE, CLIENT_KEY, ROOT_CERTIFICATE) in order to connect to the target database using the SSL connection. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
 +| **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 "Yes". \\ Possible values - allow, disable, prefer, requirer, verify-ca, verify-full. |
 +| **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 "Yes". |
 +| **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 "Yes". |
 +| **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 "Yes". |
  
  
sqlways/command-line/sqlways-ini/postgresql-section.1542366369.txt.gz · Last modified: November 16, 2018, 11:06:09 AM by darya.prikhodkina
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement