Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:mysql-section [September 07, 2018, 01:12:54 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:mysql-section [September 20, 2018, 11:48:36 AM] (current)
alexandr.kirpichny
Line 27: Line 27:
 | **KEY_LENGTH_FOR_BLOB_IDX** | If MySQL index is created on BLOB/TEXT columns, key length value should be specified for such columns. So this option defines the key length value for BLOB/TEXT columns that are used in indexes. \\ Possible values - number from 0 and higher. \\ Default value - 255. |ENABLE_LOCAL_LOAD | **KEY_LENGTH_FOR_BLOB_IDX** | If MySQL index is created on BLOB/TEXT columns, key length value should be specified for such columns. So this option defines the key length value for BLOB/TEXT columns that are used in indexes. \\ Possible values - number from 0 and higher. \\ Default value - 255. |ENABLE_LOCAL_LOAD
 | **ENABLE_LOCAL_LOAD** | This option controls the local data load into MySQL database. If this option is set to Yes, mysql.exe utility will be run with the local-infile option, which allows to use LOAD DATA LOCAL command in the .ldi file to load data into the target server from the local machine. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". | | **ENABLE_LOCAL_LOAD** | This option controls the local data load into MySQL database. If this option is set to Yes, mysql.exe utility will be run with the local-infile option, which allows to use LOAD DATA LOCAL command in the .ldi file to load data into the target server from the local machine. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "Yes". |
 +| **CREATE_DEFINER** | This option controls whether the definer clause should be added to the procedures, functions and triggers when migrating into MySQL database. In this option we need to specify a user that will be used in CREATE DEFINER clause in generated MySQL code. If this option is set to "No" or empty, CREATE DEFINER clause will not be added to the MySQL objects.\\ Default value - "No" or Empty. |
 +| **PRESERVE_COMMENTS** | This option controls whether the comments inside the sql should be saved during the import process. If this option is set to "Yes", SQLWays will generate command to mysql.exe utility with the option ”–comments”. And mysql.exe utility will save the comments inside the sql code during the import. If this option is set to "No", SQLWays will use ”–skip comments” option with mysql.exe utility. And this utility will not save comments inside the SQL code during the import.\\ Possible values - "Yes" or "No". \\ Default value - "No" or Empty. |
 +| **CREATE_CONDITION_HANDLER** | This option was created to emulate the Transact-SQL behavior inside the MySQL stored procedures and functions when the error in one of the statements inside the procedure or function body arises. By default this option is set to "Yes". And SQLWays adds the CONDITION HANDLER to each “BEGIN…END” block that handles the error arose without terminating the procedure or function execution. The errors are hidden in this case. When this option is set to "No", no CONDITION HANDLER is added and the first error encountered during the procedure or function run terminates the procedure or function execution. The error message is returned after the procedure terminates. \\ Possible values - "Yes" or "No". \\ Default value - "Yes". |
 +| **USE_FN_CHARACTERISTIC** | This option defines whether the characteristic block will be generated for MySQL functions. \\ Possible values - "Yes" or "No" or Empty. \\ Default value - "No" or Empty. |
 +| **BIT_DATATYPE** | This option defines how to convert BIT data types into MySQL database. \\ Default value - CHAR(1). |
  
 **Example**: **Example**:
sqlways/command-line/sqlways-ini/mysql-section.1536325974.txt.gz · Last modified: September 07, 2018, 01:12:54 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement