SQL Server Export
Configuration for SQL Server migration
Control SQL Server export behavior
-
DROP_ROWVERSION
PostgreSQL has no equivalent to rowversion datatype and feature. If you want to remove these useless columns, enable this directive. Columns of datatype 'rowversion' or 'timestamp' will not be exported.
-
CASE_INSENSITIVE_SEARCH
Emulate the same behavior of MSSQL with case-insensitive search. If the value is citext, it will use the citext data type instead of char/varchar/text in tables DDL (Ora2Pg will add a CHECK constraint for columns with a precision). Instead of citext, you can also set a collation name that will be used in the column definitions. To disable case-insensitive search set it to: none.
-
SELECT_TOP
Appends a TOP N clause to the SELECT command used to extract the data from SQL Server. This is equivalent to a WHERE ROWNUM < 1000 clause for Oracle.
