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 [November 30, 2018, 02:41:37 PM]
alexandr.kirpichny [Sqlways.ini File - Section [MYSQL]]
sqlways:command-line:sqlways-ini:mysql-section [November 30, 2018, 02:42:04 PM] (current)
alexandr.kirpichny [Sqlways.ini File - Section [MYSQL]]
Line 17: Line 17:
 | **IMPORT_FROM_CLIENT** | If Yes is specified, the LOCAL keyword is generated for MySQL LOAD DATA INFILE command which is used to import data to MySQL. When LOCAL is specified, data files can be located on the client host. \\ If No is specified, the LOCAL keyword is not generated and data files must be located on the server before import. \\ Possible values - Yes, No. The default value is Yes. | | **IMPORT_FROM_CLIENT** | If Yes is specified, the LOCAL keyword is generated for MySQL LOAD DATA INFILE command which is used to import data to MySQL. When LOCAL is specified, data files can be located on the client host. \\ If No is specified, the LOCAL keyword is not generated and data files must be located on the server before import. \\ Possible values - Yes, No. The default value is Yes. |
 | **DATA_LOAD_OPTION** | If Replace is specified, existing rows will be updated in an existing table based on primary or unique key information or added to the table if a primary key is not matched. If Ignore is specified, existing rows in the table will not be updated, when primary or unique key values are equivalent to existing values in the table. The rows from the text file which do not match primary or unique key in the table are inserted. | | **DATA_LOAD_OPTION** | If Replace is specified, existing rows will be updated in an existing table based on primary or unique key information or added to the table if a primary key is not matched. If Ignore is specified, existing rows in the table will not be updated, when primary or unique key values are equivalent to existing values in the table. The rows from the text file which do not match primary or unique key in the table are inserted. |
-| **ENABLE_PARTITIONING** | This option controls partitioned tables conversion for Oracle to MySQL and MSSQL to MySQL migration directions. If it is set to Yes, partitioning for tables conversion will be also migrated to target MySQL database. Otherwise partitioning will be omitted. Possible values are Yes, No. The default value is No. |+| **ENABLE_PARTITIONING** | This option controls partitioned tables conversion for Oracle to MySQL and MSSQL to MySQL migration directions. If it is set to Yes, partitioning for tables conversion will be migrated to target MySQL database. Otherwise partitioning will be omitted. Possible values are Yes, No. The default value is No. |
 | **EXISTS2JOIN** | If it is set to Yes, all the occurrences of EXISTS clauses in SELECT statements will be replaced by the tables placed to common FROM clause and conditions placed to common WHERE clause. Possible values - Yes, No. The default value is No. | | **EXISTS2JOIN** | If it is set to Yes, all the occurrences of EXISTS clauses in SELECT statements will be replaced by the tables placed to common FROM clause and conditions placed to common WHERE clause. Possible values - Yes, No. The default value is No. |
 | **IN2JOIN** | If this option is set to Yes, all the occurrences of IN clauses in WHERE condition will be moved to JOIN conditions with ON clause. Possible values - Yes, No. The default value is No. | | **IN2JOIN** | If this option is set to Yes, all the occurrences of IN clauses in WHERE condition will be moved to JOIN conditions with ON clause. Possible values - Yes, No. The default value is No. |
sqlways/command-line/sqlways-ini/mysql-section.txt · Last modified: November 30, 2018, 02:42:04 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement