This text-box lets you specify the path to the folder containing the mysql.exe tool. Usually path specification is not required as SQLWays automatically searches for the BIN directory. If the text-box is empty, first it searches the PATH variable, then it searches the registry. If it failed to find the path to the mysql.exe, no path is added to the command and system may return the error on the command execution.

This option lets you specify the type of the tables created in 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 InnoDB is selected, SQLWays generates the TYPE=InnoDB clause in the CREATE TABLE statements for MySQL, like:

CREATE TABLE customer
 (
  id INT,
  name VARCHAR(30)
 ) TYPE=InnoDB;

Data load option combo-box contains the following values: Default, Replace and Ignore. Each of them specifies the behavior of the LOAD DATA INFILE command on the data load into the primary or unique key columns in the table.

• Default - means that the LOAD command rises an error if the key with the same value already exists in the table. When Default is specified in the Wizard nothing is added to the LOAD command syntax.
• Replace - means that the LOAD command replaces the rows of data with the new rows where the primary or unique keys match. The REPLACE keyword is added to the LOAD command syntax.
• Ignore - means that the LOAD command doesn't insert the rows of data where the primary or unique keys match the existing in the table. The IGNORE keyword is added to the LOAD command syntax.

Specifies for the loader how to interpret the data stored in the txt file to be loaded to the database. If no character set is specified then the default target database character set is used.
You can choose a character set from the list or enter it manually:

This option lets you specify whether the data files reside on the local computer or on the MySQL server.

By default the Import from client check-box is selected, so the LOCAL keyword is added for the MySQL LOAD DATA INFILE command that is used for importing data to MySQL. When LOCAL is specified, data files must reside on the client host.

If the Import from client check-box is not selected, the LOCAL keyword is not added to the command and data files must reside on the server.

By default the Preserve comments check box is not selected.If checked this option adds to mysql.exe command ”–comments”. By default command ”–skip comments” used in mysql.exe

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 the Create condition handler check-box is selected. So, 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 the Create condition handler check-box is unchecked 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.

This text-box lets you specify the path to the folder containing the psql.exe tool. Usually path specification is not required as SQLWays automatically searches for the BIN directory. If the text-box is empty, first it searches the PATH variable, then it searches the registry. If it failed to find the path to the psql.exe, no path is added to the command and system may return the error on the command execution.

In PostgreSQL tables and indexes can be stored in separate tablespaces. In SQLWays you can specify the tablespace for Tables or Indexes in the target PostgreSQL database, or Use tablespace names from source database in the Tablespaces section of the Advnaced page.

OID column is a system column created for each table. It contains the unique identifier for the row of data in the database and can be used as a unique pointer to the exact record in the database. As the default the check-box is checked. This means that all the CREATE TABLE statements will be created with the WITH OIDS option.

SQLWays Migration Product Page Free Evaluation