Differences

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

--- sqlways:command-line:sqlways-ini:msazuresql-section [December 21, 2018, 09:25:15 AM] – darya.prikhodkina
+++ sqlways:command-line:sqlways-ini:msazuresql-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 \\
-[[http://www.ispirer.com|Ispirer Home Page]]
+[[https://www.ispirer.com|Ispirer Website]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
+[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]]
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Sqlways.ini File - Section [MSAZURESQL] ======
@@ Line 22: / Line 22: @@
 | **TABLE_FILEGROUP** | This option defines FILEGROUP for tables.   |
 | **INDEX_FILEGROUP** | This option defines FILEGROUP 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. \\ 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. \\ 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**:
@@ Line 29: / Line 32: @@
   CASE_SENSITIVE_COLLATION=No
-\\
-[[http://www.ispirer.com|Ispirer Home Page]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]