Differences

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

Link to this comparison view

guides:migration-toolkit:command-line:sqlways-ini:wizard_common-section [2019/06/11 00:26]
127.0.0.1 external edit
guides:migration-toolkit:command-line:sqlways-ini:wizard_common-section [2019/11/16 11:42] (current)
darya.prikhodkina
Line 7: Line 7:
 | **AUTOSTART_IMPORT** | This option defines whether the import process will be run automatically after the conversion. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. | | **AUTOSTART_IMPORT** | This option defines whether the import process will be run automatically after the conversion. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. |
 | **USE_IMPORT_LOG_ANALYZER** | If this option is set to "​Yes",​ SQLWays Wizard tool will try to analyze the import process according the the information in the import log file, and generate summary information at the end of the import log file. Can be used only for MySQL database as a target. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. | | **USE_IMPORT_LOG_ANALYZER** | If this option is set to "​Yes",​ SQLWays Wizard tool will try to analyze the import process according the the information in the import log file, and generate summary information at the end of the import log file. Can be used only for MySQL database as a target. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. |
-| **PRECACHE_OBJECTS** | If this option is set to "​Yes",​ SQLWays Wizard tool will try to use cache technology and select information about all the tables in database using only one sql query. If this query is set to "​No",​ separate queries will be used to get information about each table. This option will work only when the number of tables specified for conversion is larger than the number provided in the PRECACHE_TABLES_COUNT option. The performance can be improved only when the number specified in the PRECACHE_TABLES_COUNT option is more than 51% of all the tables in the database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. | +| **PRECACHE_OBJECTS** | If this option is set to "​Yes",​ SQLWays Wizard tool will try to use cache technology and select information about all the tables in database using only one sql query. If it is set to "​No",​ separate queries will be used to get information about each table. This option will work only when the number of tables specified for conversion is larger than the number provided in the PRECACHE_TABLES_COUNT option. The performance can be improved only when the number specified in the PRECACHE_TABLES_COUNT option is more than 51% of all the tables in the database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​. | 
-| **PRECACHE_TABLES_COUNT** | Specifies the minimum number of tables that should be specified for conversion in order to use "​precache"​ technology. \\ Default value - "101". |+| **PRECACHE_TABLES_COUNT** | Specifies the minimum number of tables that should be specified for conversion in order to use "​precache"​ technology. \\ Default value - 101. |
 | **REPLACE_RESERVED_WORDS** | This option replaces reserved words with the pattern provided in the option. | | **REPLACE_RESERVED_WORDS** | This option replaces reserved words with the pattern provided in the option. |
 | **STARTROW** | This option defines the number of the first row that will be extracted from a table. \\ Default value - 1. | | **STARTROW** | This option defines the number of the first row that will be extracted from a table. \\ Default value - 1. |
Line 16: Line 16:
 | **TRACE** | This option allows to run the conversion in "Trace mode". If this option is set to "​Yes",​ commented source code of the object will be added to the sql files. Sqlways.trc file, which contains detailed information about the conversion process will be generated as well.  \\ Default value - "​sqlways.log"​. | | **TRACE** | This option allows to run the conversion in "Trace mode". If this option is set to "​Yes",​ commented source code of the object will be added to the sql files. Sqlways.trc file, which contains detailed information about the conversion process will be generated as well.  \\ Default value - "​sqlways.log"​. |
 | **DIVIDE_DATA_FILE_INTO_PARTS** | This option allows to generate multiple text files that store data for one table. If this option is set to "​Yes",​ multiple .txt files will be generated. The maximum size of each file is by default equal to 2GB.  \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​ or Empty. | | **DIVIDE_DATA_FILE_INTO_PARTS** | This option allows to generate multiple text files that store data for one table. If this option is set to "​Yes",​ multiple .txt files will be generated. The maximum size of each file is by default equal to 2GB.  \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​No"​ or Empty. |
-| **GENERATE_IMPORT_SCRIPTS** | If this option is set to Yes, SQLWays Wizard will generate all the files required for performing import into the target database. Such files are ctl, .ldi and .bat files. If this option is set to "​No",​ such files will not be generated. This option can also be set on the "​Choose a Target Database"​ page of the SQLWays Wizard tool. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. | +| **GENERATE_IMPORT_SCRIPTS** | If this option is set to "Yes", SQLWays Wizard will generate all the files required for performing import into the target database. Such files are ctl, .ldi and .bat files. If this option is set to "​No",​ such files won'​t ​be generated. This option can also be set on the "​Choose a Target Database"​ page of the SQLWays Wizard tool. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. | 
-| **EXPORT_DATA** | This option defines data export process. If this option is set to "​Yes",​ SQLWays will extract the data from source database. If it is set to "​No",​ data export will be omitted. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. |+| **EXPORT_DATA** | This option defines data export process. If this option is set to "​Yes",​ SQLWays will extract the data from the source database. If it is set to "​No",​ data export will be omitted. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. |
 | **GENERATE_DDL_SCRIPTS** | If this option is set to "​Yes",​ SQLWays tool will generate ddl files with the converted table definitions. If it is set to "​No",​ ddl files will not be generated and only data will be extracted from a source database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. | | **GENERATE_DDL_SCRIPTS** | If this option is set to "​Yes",​ SQLWays tool will generate ddl files with the converted table definitions. If it is set to "​No",​ ddl files will not be generated and only data will be extracted from a source database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. |
 | **READ_DDL_SCRIPTS** | If this option is set to "​Yes",​ SQLWays tool will generate ddl files with the converted table definitions. If it is set to "​No",​ ddl files will not be generated and only data will be extracted from source database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. | | **READ_DDL_SCRIPTS** | If this option is set to "​Yes",​ SQLWays tool will generate ddl files with the converted table definitions. If it is set to "​No",​ ddl files will not be generated and only data will be extracted from source database. \\ Possible values - "​Yes",​ "​No"​ or Empty. \\ Default value - "​Yes"​. |