Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
guides:migration-toolkit:command-line:sqlways-ini:sql-server-section [2019/11/01 08:38]
alexandr.kirpichny
guides:migration-toolkit:command-line:sqlways-ini:sql-server-section [2019/11/06 10:35]
alexandr.kirpichny
Line 35: Line 35:
 | **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**:​