This is an old revision of the document!



Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [MYSQL]

This article describes sqlways.ini file [MYSQL] section and the options it contains.

Option name Description
BIN Specifies the directory where MySQL utilities are located.
HOST Specifies a remote host name where a target MySQL database resides.
DATABASE Specifies the database name which is used in generated scripts for MySQL.
PORT This option sets port number that will be used to connect to MySQL database.
TARGET_VERSION Specifies the target version of the MySQL database. If this option is empty the latest MySQL database version will be used.
Note: According to the version number conversion results may be different.
USER Specifies the user name which is used in generated scripts for MySQL.
PWD Specifies the user password which is used in generated scripts for MySQL.
TABLE_TYPE This option specifies the table type which is used when creating tables in a MySQL database. MySQL supports two different kinds of tables: transaction-safe tables (InnoDB and BDB) and not transaction-safe tables (HEAP, ISAM, MERGE, and MyISAM).
For example, when table_type=InnoDB is selected, SQLWays generates TYPE=InnoDB clause in CREATE TABLE statements for MySQL.
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 importing.
Possible values - Yes, No. The default value is Yes.
DATA_LOAD_OPTION If Replace is specified, existing rows are 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 are not 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 was added for Oracle to MySQL conversion. If it is Yes, all the columns from partition clause which are not in primary key are added to primary key definition. If it is No or not specified, all partition clauses are removed from a MySQL equivalent. Possible values are Yes, No. The default is No.
EXISTS2JOIN If it is Yes, all the occurrences of EXISTS clauses in SELECT statements are replaced with the tables placed to common FROM clause and conditions placed to common WHERE clause. Possible values - Yes, No. The default is No.
IN2JOIN If this option is Yes, all the occurrences of IN clauses in WHERE condition are moved to JOIN conditions with ON clause. Possible values - Yes, No. The default is No.
FOREIGN_KEY_CHECKS This option was added to ignore foreign key constraints during LOAD DATA operation and ignore check of data when adding FOREIGN KEY constraints to the table. Possible values - Yes, No. The default is No.
CONVERT_PARTITIONS This option allows to convert RANGE and LIST partitions for Oracle to MySQL conversion direction.
Possible values - “Yes”, “No” or empty. Default value - “No” or empty.
CHARACTER_SET This option defines the encoding that will be used to store the extracted data in the files in export folder.
SSL_CA This option defines the path to a file in PEM format that contains a list of trusted SSL certificate authorities.
Default value - Empty.
SSL_MODE This option specifies the security state of the connection to the server.
Possible values - PREFERRED, DISABLED, REQUIRED, VERIFY_CA, VERIFY_IDENTITY and Empty.
Default value - Empty.
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 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”.

Example:

[MySQL]
HOST=hostname
DATABASE=test
USER=root
SSL_CA=D:\test\ca-file.pem
SSL_MODE=VERIFY_IDENTITY


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.