Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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 [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
====== Sqlways.ini File - Section [_WZD_COMMON] ====== | ====== Sqlways.ini File - Section [_WZD_COMMON] ====== | ||
- | This article describes sqlways.ini file [_WZD_COMMON] section and the options it contains. | + | This article describes sqlways.ini file' |
^ Option name ^ Description | ^ Option name ^ Description | ||
- | | **GENERATE_IMPORT_SCRIPTS** | If this option is set to Yes, SQLWays Wizard will generate all the files required for making | + | | **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 - " |
- | | **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. | | + | | **AUTOSTART_IMPORT** | This option defines whether the import process will be run automatically after the conversion. \\ Possible values - " |
+ | | **USE_IMPORT_LOG_ANALYZER** | If this option is set to " | ||
+ | | **PRECACHE_OBJECTS** | If this option is set to " | ||
+ | | **PRECACHE_TABLES_COUNT** | Specifies the minimum number of tables that should be specified for conversion in order to use " | ||
+ | | **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. | | ||
+ | | **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. The folder will be generated in the export directory. \\ Default value - " | ||
+ | | **LOG** | This option defines the name of the conversion log file. This is a log file that will be generated during the conversion. \\ Default value - " | ||
+ | | **TRACE** | This option allows to run the conversion in "Trace mode". If this option is set to " | ||
+ | | **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 " | ||
+ | | **GENERATE_IMPORT_SCRIPTS** | If this option is set to Yes, SQLWays Wizard will generate all the files required for performing | ||
+ | | **EXPORT_DATA** | This option defines data export process. If this option is set to " | ||
+ | | **GENERATE_DDL_SCRIPTS** | If this option is set to " | ||
+ | | **READ_DDL_SCRIPTS** | If this option is set to " | ||
+ | | **REPLACE_NOT_ALLOWED_CHARS_FPOS** | In 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 the 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. | | ||
- | | **USE_QUERY_FOR_EXPORT** | If this option is set to " | + | | **USE_QUERY_FOR_EXPORT** | If this option is set to " |
- | | **EXPORT_QUERY_FROM_FILE** | If this option is set to " | + | | **EXPORT_QUERY_FROM_FILE** | If this option is set to " |
- | | **EXPORTQUERYTEXT** | This option contains stored queries, that will be used to extract data from the source database. Queries are separated using the " | + | | **EXPORTQUERYTEXT** | This option contains stored queries that will be used to extract data from a source database. Queries are separated using the " |
- | | **EXPORTQUERYFILE** | This option works only when " | + | | **EXPORTQUERYFILE** | This option works only when " |
- | | **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 " | + | | **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 " |
- | | **EXPORTQUERYTARGETNAMESFILE** | This option works only if " | + | | **EXPORTQUERYTARGETNAMESFILE** | This option works only if the " |
**Example**: | **Example**: | ||
Line 24: | Line 39: | ||
\\ | \\ | ||
- | If you have any questions | + | If you have any questions |
- | \\ | ||
- | [[http:// | ||
- | [[http:// | ||
- | [[http:// |