Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:sql-server-section [October 31, 2019, 02:05:37 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:sql-server-section [November 06, 2019, 10:37:18 AM] (current)
alexandr.kirpichny
Line 38: Line 38:
 | **TABLE_FILEGROUP** | This option defines FILGROUP for tables. | | **TABLE_FILEGROUP** | This option defines FILGROUP for tables. |
 | **INDEX_FILEGROUP** | This option defines FILGROUP for indexes. | | **INDEX_FILEGROUP** | This option defines FILGROUP for indexes. |
-| **FK_DEL_CASCADE_SET_NULL_TO_TRIG** | This option defines how to convert ON DELETE CASCADE and ON DELETE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON DELETE CASCADE and ON DELETE SET NULL foreign key options will be converted into a trigger that emulates the same behavior as in Firebird. | +| **FK_DEL_CASCADE_SET_NULL_TO_TRIG** | This option defines how to convert ON DELETE CASCADE and ON DELETE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON DELETE CASCADE and ON DELETE SET NULL foreign key options will be converted into a trigger that emulates the same behavior as in Firebird. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
-| **FK_UPD_CASCADE_SET_NULL_TO_NO_ACT** | This option defines how to convert ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options will be converted into ON UPDATE NO ACTION in Microsoft SQL Server. |+| **FK_UPD_CASCADE_SET_NULL_TO_NO_ACT** | This option defines how to convert ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options will be converted into ON UPDATE NO ACTION in Microsoft SQL Server. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
 +| **USE_SCOPE_IDENTITY** | This option defines how to convert @@identity global variable when migrating from Sybase Adaptive Server Anywhere to Microsoft SQL Server. If it is set to Yes, then @@identity will be converted to SCOPE_IDENTITY() in Microsoft SQL Server. If this option is set to No, then @@identity global variable will be left as is in MS SQL. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. | 
  
 **Example**: **Example**:
sqlways/command-line/sqlways-ini/sql-server-section.txt · Last modified: November 06, 2019, 10:37:18 AM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement