Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
faq:migration-toolkit:test-features [2019/09/20 10:32] darya.prikhodkina [Option TEST] |
faq:migration-toolkit:test-features [2019/09/20 10:51] darya.prikhodkina [Option TEST] |
||
---|---|---|---|
Line 9: | Line 9: | ||
There are two ways to specify the TEST option when running our toolkit: | There are two ways to specify the TEST option when running our toolkit: | ||
- /TEST - when running from command-line; | - /TEST - when running from command-line; | ||
- | - TEST=Yes - in the **[COMMON]** section of the [[guides:migration-toolkit/command-line/sqlways-ini|sqlways.ini]] or sqlways_wzd.ini. | + | - TEST=Yes - in the **[COMMON]** section of the [[guides:migration-toolkit/command-line/sqlways-ini|sqlways.ini]] or sqlways_wzd.ini file. |
Option TEST is used to generate calling statements for procedures or functions converted either from scripts or from a database. If this option is set the conversion is not performed and only calling statements are generated. Please refer to the following example: | Option TEST is used to generate calling statements for procedures or functions converted either from scripts or from a database. If this option is set the conversion is not performed and only calling statements are generated. Please refer to the following example: | ||
- | Assume you have the source Sybase ASE procedure. If the TEST option is not specified the conversion to Oracle is as follows: \\ | + | Assume you have the source Sybase ASE procedure. If the TEST option is not specified, conversion to Oracle will be as follows: \\ |
**Table1** | **Table1** | ||
Line 19: | Line 19: | ||
|create procedure sp_proc \\ as \\ declare @x int \\ select @x= 2 \\ GO |create or replace procedure sp_proc \\ as \\ v_x NUMBER(10,0); \\ BEGIN \\ v_x := 2; \\ END; | | |create procedure sp_proc \\ as \\ declare @x int \\ select @x= 2 \\ GO |create or replace procedure sp_proc \\ as \\ v_x NUMBER(10,0); \\ BEGIN \\ v_x := 2; \\ END; | | ||
- | When the TEST option is ON the following calling statement is generated instead of the converted syntax: \\ | + | When the TEST option is ON the following calling statement will be generated instead of the converted syntax: \\ |
**Table2** | **Table2** |