Differences

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

--- guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2019/11/16 09:51]
darya.prikhodkina
+++ guides:migration-toolkit:command-line:sqlways-ini:postgresql-section [2022/08/03 11:10]
alina.svidunovich
@@ Line 22: / Line 22: @@
 | **ROWNUM_TO_GENERATE_SERIES** | This option controls how Oracle Rownum function will be converted to PostgreSQL database. If this option is set to "Yes", 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 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, "No" value should be specified. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes" or Empty. |
+| **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, "No" value should be specified. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes" or Empty. |
-| **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 the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. By default this option is set to "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
+| **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 the unique identifier for the row of data in the database and can be used as a unique pointer to an exact record in the database. By default this option is set to "Yes". This means that all the CREATE TABLE statements will be created with the WITH OIDS option.   \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
 | **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. |
 | **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. |
+| **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. |
 **Example**: