Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:wizard_common-section [October 12, 2018, 01:54:58 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:wizard_common-section [October 18, 2018, 12:51:39 PM] (current)
alexandr.kirpichny
Line 7: Line 7:
 This article describes sqlways.ini file [_WZD_COMMON] section and the options it contains.  This article describes sqlways.ini file [_WZD_COMMON] section and the options it contains. 
 ^  Option name  ^ Description  ^  ^  Option name  ^ Description  ^ 
 +| **RUN_IMPORT_REMOTLY** | This option defines whether the import process will be run from a remote machine. It means that all the generated files will be copied to another, remote machine. And import will be run from that machine. \\ Possible values - "Yes", "No" or Empty. \\ Default values - "No". |
 +| **AUTOSTART_IMPORT** | This option defines whether the import process will be run automatically, after the conversion step. \\ Possible values - "Yes", "No" or Empty. \\ Default values - "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 values - "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", will be used separate queries to get information about each table. This option will work only when number of tables specified for conversion is greater than number provided in the PRECACHE_TABLES_COUNT option. Can improve the performance only when the number specified in the PRECACHE_TABLES_COUNT option is greater than 51% of all the tables in the database. \\ Possible values - "Yes", "No" or Empty. \\ Default values - "No". |
 +| **PRECACHE_TABLES_COUNT** | Specifies the minimum number of tables that should be specified for conversion to use "precache" technology. \\ Default value - "101". |
 +| **REPLACE_RESERVED_WORDS** | This option replace reserved words with the pattern provided inside the option. |
 +| **STARTROW** | This option defines the number of the first row that will be extracted from a table. \\ Default value - 1. |
 +| **ROWSCOUNT** | This option defines the number of rows that will be extracted from a table. If this option is not set or empty, all the rows will be extracted. \\ Default value - Empty. |
 +| **RPT** | This option defines the name of the folder where all the report files will be placed. Folder will be generated in the export directory. \\ Default value - "reports". |
 +| **LOG** | This option defines the name of the conversion log file. This is a log file that will be generated during the conversion stage. \\ Default value - "sqlways.log". |
 +| **TRACE** | This option allows to run the conversion in "Trace mode". If this option is set to "Yes", in the sql files will be added commented source code of the object. Also will be generated sqlways.trc file, this is a trace file that stores information about the   \\ Default value - "sqlways.log". |
 +| **DIVIDE_DATA_FILE_INTO_PARTS** | This option allows to generate multiple text files that stores data for one table. If this option is set to "Yes", will be generated multiple .txt files. Maximum size of each file is equal to 2GB, by default.  \\ 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 making import into the target database. Such files as ctl, .ldi and .bat files. If this option is set to "No", such files will not be generated. Also this option can be set in the SQLWays Wizard tool, on the "Choose a Target Database" page. \\ 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 making import into the target database. Such files as ctl, .ldi and .bat files. If this option is set to "No", such files will not be generated. Also this option can be set in the SQLWays Wizard tool, on the "Choose a Target Database" page. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
 +| **EXPORT_DATA** | This option defines the data export process. If this option is set to "Yes", SQLWays will extract the the data from source database. If it 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 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". |
 | **REPLACE_NOT_ALLOWED_CHARS_FPOS** | Some databases identifier names could contain specific characters that may not be allowed in the target database. This option was created in order to replace such characters only from first position. Character that will replace not allowed characters should be specified in this option. | | **REPLACE_NOT_ALLOWED_CHARS_FPOS** | Some databases identifier names could contain specific characters that may not be allowed in the target database. This option was created in order to replace such characters only from first position. Character that will replace not allowed characters should be specified in this option. |
 | **REPLACE_NOT_ALLOWED_CHARS** | In some databases identifier names could have specific characters that may not be allowed in the target database. This option was created in order to replace such characters. –°haracter that will replace not allowed characters should be specified in this option. | | **REPLACE_NOT_ALLOWED_CHARS** | In some databases identifier names could have specific characters that may not be allowed in the target database. This option was created in order to replace such characters. –°haracter that will replace not allowed characters should be specified in this option. |
Line 15: Line 30:
 | **EXPORTQUERYFILE** | This option works only when "EXPORT_QUERY_FROM_FILE" option is set to "Yes". In this option we need to define a path to the sql file with the queries, that will be used to extract data from the source database. | | **EXPORTQUERYFILE** | This option works only when "EXPORT_QUERY_FROM_FILE" option is set to "Yes". In this option we need to define a path to the sql file with the queries, that will be used to extract data from the source database. |
 | **EXPORTQUERYTARGETNAMES** | In this option target table names should be specified, they will be used in the CREATE TABLE statements, that will be built for each query defined in the "EXPORTQUERYTEXT" option. Table names should be separated using the "\\". | | **EXPORTQUERYTARGETNAMES** | In this option target table names should be specified, they will be used in the CREATE TABLE statements, that will be built for each query defined in the "EXPORTQUERYTEXT" option. Table names should be separated using the "\\". |
-| **EXPORTQUERYTARGETNAMESFILE** | This option works only if "EXPORT_QUERY_FROM_FILE" option is set to "Yes". This option should specify a path to the file, that will store target table names for tables that will be created in the target database. |+| **EXPORTQUERYTARGETNAMESFILE** | This option works only if the "EXPORT_QUERY_FROM_FILE" option is set to "Yes". This option should specify a path to the file, that will store target table names for tables that will be created in the target database. |
  
 **Example**: **Example**:
sqlways/command-line/sqlways-ini/wizard_common-section.1539352498.txt.gz · Last modified: October 12, 2018, 01:54:58 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement