Differences

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

--- guides:migration-toolkit:command-line:sqlways-ini:sql-server-section [2019/11/16 11:01]
darya.prikhodkina
+++ guides:migration-toolkit:command-line:sqlways-ini:sql-server-section [2022/08/03 09:07]
alina.svidunovich
@@ Line 38: / Line 38: @@
 | **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. |
+| **CONVERT_SP_TO_SP** | The option is responsible for ensuring that objects that can be converted to functions are still converted to procedures. The value of the option specifies the path to the file in which objects names that have to be converted as procedures are specified as an XML structure, e.g. CONVERT_SP_TO_SP=C:\\Users\\Documents\\Ispirer\\pr.xml \\ where the content of the pr.xml file is: \\ <Procedures> \\ <Procedure Name=“sproc1” /> \\ <Procedure Name=“sproc2” /> \\ </Procedures> |
 **Example**: