Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:mariadb-section [December 21, 2018, 10:18:18 AM]
darya.prikhodkina
sqlways:command-line:sqlways-ini:mariadb-section [February 04, 2019, 12:52:44 PM] (current)
alexandr.kirpichny
Line 18: Line 18:
 | **TABLE_TYPE** | This option specifies the table type which is used when creating tables in MariaDB database. MariaDB 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 TYPE=InnoDB clause in CREATE TABLE statements for MariaDB. | | **TABLE_TYPE** | This option specifies the table type which is used when creating tables in MariaDB database. MariaDB 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 TYPE=InnoDB clause in CREATE TABLE statements for MariaDB. |
 | **DATA_LOAD_OPTION** | If Replace is specified, existing rows are updated in an existing table based on primary or unique key information or added to the table if a primary key is not matched. If Ignore is specified, existing rows in the table are not updated, when primary or unique key values are equivalent to existing values in the table. The rows from the text file which do not match primary or unique key in the table are inserted. | | **DATA_LOAD_OPTION** | If Replace is specified, existing rows are updated in an existing table based on primary or unique key information or added to the table if a primary key is not matched. If Ignore is specified, existing rows in the table are not updated, when primary or unique key values are equivalent to existing values in the table. The rows from the text file which do not match primary or unique key in the table are inserted. |
-| **CHARACTER_SET** | This option defines the encoding that will be used to store the extracted data in the files in export folder. |+| **CHARACTER_SET** | This option defines the encoding that will be used to store the extracted data in the files in export folder. \\ Also according to the assigned value, this option may change the conversion of VARCHAR data type into TEXT data type. For example, when migrating from Oracle database to MySQL with utf8 encoding, maximum varchar length is different. In Oracle maximum value of VARCHAR2 is equal to 32767, and in MySQL with utf8 it is - 21 844. So if this option is set to "UTF8", all the VARCHAR2 data types, with length greater than 21 844, will be converted into TEXT in MySQL. |
 | **IMPORT_FROM_CLIENT** | If Yes is specified, the LOCAL keyword is generated for MariaDB LOAD DATA INFILE command which is used to import data to MariaDB. When LOCAL is specified, data files can be located on the client host. \\ If No is specified, the LOCAL keyword is not generated, thus the data files must be located on the server before importing. \\ Possible values - Yes, No. The default value is Yes. | | **IMPORT_FROM_CLIENT** | If Yes is specified, the LOCAL keyword is generated for MariaDB LOAD DATA INFILE command which is used to import data to MariaDB. When LOCAL is specified, data files can be located on the client host. \\ If No is specified, the LOCAL keyword is not generated, thus the data files must be located on the server before importing. \\ Possible values - Yes, No. The default value is Yes. |
 | **PRESERVE_COMMENTS** | This option controls whether the comments inside the sql should be saved during the import process. If this option is set to "Yes", SQLWays will generate command to mysql.exe utility with the option ”–comments”. And mysql.exe utility will save the comments inside the sql code during the import. If this option is set to "No", SQLWays will use ”–skip comments” option with mysql.exe utility. And this utility will not save comments inside the SQL code during the import.\\ Possible values - "Yes" or "No". \\ Default value - "No" or Empty. | | **PRESERVE_COMMENTS** | This option controls whether the comments inside the sql should be saved during the import process. If this option is set to "Yes", SQLWays will generate command to mysql.exe utility with the option ”–comments”. And mysql.exe utility will save the comments inside the sql code during the import. If this option is set to "No", SQLWays will use ”–skip comments” option with mysql.exe utility. And this utility will not save comments inside the SQL code during the import.\\ Possible values - "Yes" or "No". \\ Default value - "No" or Empty. |
sqlways/command-line/sqlways-ini/mariadb-section.txt · Last modified: February 04, 2019, 12:52:44 PM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement