Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
guides:migration-toolkit:command-line:sqlways-ini:mysql-section [2019/11/01 08:42] alexandr.kirpichny |
guides:migration-toolkit:command-line:sqlways-ini:mysql-section [2023/09/08 12:42] (current) 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 30: | Line 37: | ||
| | **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. | | | **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”. \\ [[samples:options-examples #[Usage example]:RETURN_STATUS_TO|Usage example]].| | ||
| + | | **DEFAULT_AUTH_PLUGIN** | This option adds option –default-auth=plugin_name on the command line of mysql.exe utility during import objects to SingleStoreDB database. The –default-auth=plugin_name option can be specified on the command line as a hint about which client-side plugin the program can expect to use, although the server overrides this if the server-side plugin associated with the user account requires a different client-side plugin. \\ Possible values - mysql_native_password, caching_sha2_password, mysql_old_password, sha256_password and Empty. \\ Default value - Empty. | | ||
| **Example**: | **Example**: | ||
| Line 42: | Line 52: | ||
| \\ | \\ | ||
| - | ---- | + | |
| - | === 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]] | + | |