Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:mysql-section [2019/10/18 11:26] darya.prikhodkina |
guides:migration-toolkit:command-line:sqlways-ini:mysql-section [2023/06/01 16:13] alina.svidunovich |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ** About Ispirer Systems ** | ||
| + | |||
| + | [[https://www.ispirer.com|Ispirer Home Page]] | ||
| + | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
| + | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
| + | [[https://www.ispirer.com/download|Downloads]] | ||
| + | ---- | ||
| ====== Sqlways.ini File - Section [MYSQL] ====== | ====== Sqlways.ini File - Section [MYSQL] ====== | ||
| Line 29: | Line 36: | ||
| | **BIT_DATATYPE** | This option defines how to convert BIT data types into MySQL database. \\ Default value - CHAR(1). | | | **BIT_DATATYPE** | This option defines how to convert BIT data types into MySQL database. \\ Default value - CHAR(1). | | ||
| | **KEEP_INCLUDED_COLUMNS** | This option defines whether the INCLUDED columns is kept in the index definitions or not. \\ Possible values - "Yes" or "No". \\ Default value - "Yes" or Empty. | | | **KEEP_INCLUDED_COLUMNS** | This option defines whether the INCLUDED columns is kept in the index definitions or not. \\ Possible values - "Yes" or "No". \\ Default value - "Yes" or Empty. | | ||
| + | | **VARCHAR_PAR_LEN** | This option defines the length of VARCHAR parameters when converting from Oracle to MySQL. If this option is empty, then will be used 4000 as a length of varchar parameters in MySQL. If this option is set to a some value, then this value will be used as a length of a VARCHAR parameter in MySQL. | | ||
| + | | **CLIENT_CHARACTER_SET** | This option adds option –default-character-set=charset_name in the .bat file in the command line for mysql.exe. Default value - Empty. | | ||
| + | | **RETURN_STATUS_TO** | This option defines conversion of procedure that returns result set from RETURN statement. If this option is set to “INOUT” in MySQL, the result set from RETURN statement will be converted to INOUT parameter of procedure. If this option is set to “LOCAL” , then the statement RETURN should be ignored and no additional parameter in target should be created . Possible values - “INOUT” or "LOCAL". Default value - “INOUT”. | | ||
| **Example**: | **Example**: | ||
| Line 41: | Line 51: | ||
| \\ | \\ | ||
| - | ---- | + | |
| - | === More about Ispirer Systems === | + | |
| - | [[https://www.ispirer.com|Ispirer Home Page]] | + | |
| - | [[https://www.ispirer.com/products/database-migration|Database Migration]] | + | |
| - | [[https://www.ispirer.com/application-conversion|Application Conversion]] | + | |
| - | [[https://www.ispirer.com/download|Downloads]] | + | |