Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

[MySQL] Subsection

This subsection is used to adjust script generations when MySQL is the target database, and to specify properties when it is the source database.

BIN - Specifies the directory where the MySQL utilities are located.
HOST - Specifies a remote host name where the target MySQL database resides.
DATABASE - Specifies the database name that is used in generated scripts for MySQL.
USER - Specifies the user name that is used in generated scripts for MySQL.
PWD - Specifies the user password that is used in generated scripts for MySQL.
TABLE_TYPE - This option specifies a table type that is used when creating tables in the 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 the TYPE=InnoDB clause in the CREATE TABLE statements for MySQL.

IMPORT_FROM_CLIENT - If Yes is specified, the LOCAL keyword is generated for the MySQL LOAD DATA INFILE command that is used for importing 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.

Note. There are some issues regarding using the LOCAL keyword in MySQL 4.0.x. See LOCAL keyword - The used command is not allowed with this MySQL version.

DATA_LOAD_OPTION - If Replace is specified, existing rows are updated in the existing table basing on primary or unique key information or added to the table if primary key is not matched. If Ignore is specified the existing rows in the table are not updated, when primary or unique key values are equivalent to the existing in the table. The rows from the text file which do not match primary or unique key in the table are inserted.

To specify MySQL options using the SQLWays wizard

SQLWays Wizard - MySQL Advanced Options Page