Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sqlways:command-line:sqlways-ini:mysql-section [October 31, 2019, 02:07:57 PM] alexandr.kirpichnysqlways:command-line:sqlways-ini:mysql-section [June 05, 2023, 01:32:54 PM] (current) nevar
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] +[[https://www.ispirer.com/products/mysql-migration|Ispirer Capabilities - MySQL Migration]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]]+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Sqlways.ini File - Section [MYSQL] ====== ====== Sqlways.ini File - Section [MYSQL] ======
  
Line 34: Line 34:
 | **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”. |
 +| **DEFAULT_AUTH_PLUGIN** | This option adds option --default-auth=plugin_name on the command line of mysql.exe utility during import objects to MySQL 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 45: Line 48:
  
  
-\\ 
-[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]] 
  

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