|Conversion
This tab allows changing parameters affecting PL/SQL to Transact-SQL conversion performed by SSMA. It contains the following options:|
- Generate ROWID column - This checkbox enables or disables generation of ROWID column for converted tables, and this also affects the SQL that uses those tables. For example, trigger generation will be very limited.
- Allow sequence-to-identity conversion - This option enables or disables functionality of converting sequences to identity. If this option is selected, SSMA will generate a Transact-SQL code that emulates sequence behavior in SQL Server. That is the most general and correct solution for sequence conversion.
- Allow insertion to IDENTITY columns - If this is checked, converted SQL can have inserts to tables with IDENTITY columns. This solution may not be correct in some cases depending on business application logic, but if it fits your needs, we recommend it because that is a native SQL Server solution to handle counters.
- Show system sequences - If this option is checked, system sequences will be shown in dialogs where sequence can be used as identity. This option is only relevant when the option "Allow insertion to IDENTITY columns" is selected.
- Convert transaction processing statements - This option enables or disables conversion of SQL statements with transaction management.
- Convert exceptions - This option enables or disables conversion of exceptions in general.
Controls whether a trigger can perform an action that initiates another trigger. When cleared, triggers cannot be fired by ...
Conversion from data type "%1!s!" to data type "%2!s!" is unsupported. The source type cannot be converted to the destination ...
Conversion of Oracle ROWNUM structure may lead to the significant degradation of resulting Transact-SQL code performance. ...
Conversion Options This tab contains modes of conversion mode. There are four choices: Default - In this mode, the default ...
Conversion This tab allows changing parameters affecting PL/SQL to Transact-SQL conversion performed by SSMA. It contains ...
Conversion will save the measure group's writeback table in a permanent partition and will make the measure group read-only. ...
Converting "%1!s!" from type DT_STR to type DT_WSTR failed with error code 2!8.8X!. An error occurred while performing the ...
Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion ...
Converts a local datetime value and a time zone offset to a datetimeoffset value with the given time zone offset being perserved. ...