Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2022/08/03 11:10] alina.svidunovich |
guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2022/08/03 17:08] alina.svidunovich |
||
|---|---|---|---|
| Line 28: | Line 28: | ||
| | **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. | | ||
| + | | **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. If this option is set to “No”, then it will be converted to RAISE EXCEPTION statements. \\ Possible values - “Yes”, “No” or Empty. \\ Default value - “No” or Empty. \\ NOTE: procedure defined SWP_RAISERROR will be generated by Ispirer Ispirer Toolkit tool automatically. | | ||
| + | | **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 “All”, then will be used default conversion, and all options will be saved. \\ Possible values - “Remove” , “All” or Empty. \\ Default value - “All” or Empty. | | ||
| | **IDENTITY_TO_SERIAL** | This option controls the way how column with IDENTITY property may be converted. \\ If the option is set to "No" or Empty, the IDENTITY property will be moved for PostgreSQL. \\ If the option is set to "Yes", the IDENTITY property specified for column will be converted as SERIAL for PostgreSQL. \\ Possible values - “Yes”, "No" or Empty. Default value - "No" or Empty. | | | **IDENTITY_TO_SERIAL** | This option controls the way how column with IDENTITY property may be converted. \\ If the option is set to "No" or Empty, the IDENTITY property will be moved for PostgreSQL. \\ If the option is set to "Yes", the IDENTITY property specified for column will be converted as SERIAL for PostgreSQL. \\ Possible values - “Yes”, "No" or Empty. Default value - "No" or Empty. | | ||