Differences

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

--- guides:migration-toolkit:sqlways-wizard:database-migration-guide:conversion-options:table-options:data-options:general [2018/02/14 12:19]
+++ guides:migration-toolkit:sqlways-wizard:database-migration-guide:conversion-options:table-options:data-options:general [2023/12/15 08:33] (current)
volha.zhyrava
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== General ======
+==== Overview ====
+^ **Option Name** ^ Description ^
+| [[general#Export Data|Export Data]] | Specifies whether or not to export the data |
+| [[general#Start row|Start row]] | Specifies start row position for data export |
+| [[general#Number of rows|Number of rows]] | Specifies how many rows should be exported |
+| [[general#Boolean representation|Boolean representation]] | Specifies boolean values format |
+| [[general#Divide data file into parts of|Divide data file into parts of]] | Specify the size of data-files|
+| [[general#Skip data export if data files already exists|Skip data export if data files already exists]] | Specify the necessity to re-create data files|
+{{:guides:migration-toolkit:sqlways-wizard:database-migration-guide:conversion-options:table-options:data-options:ddl_gen_comb.jpg?nolink|}}
+==== Export data ====
+You can use the "Export Data" option to specify whether or not to export data during the migration process.
+Choose "Tables" in the tree on the left, "Data Options" tab, "General" combobox.
+If option is checked, all data from the tables is exported for the subsequent import into the target Database.
+==== Start row ====
+If you need to migrate a certain number of rows, you can control it using "Start row" and "Number of rows" option to control number of exported rows.
+"Start row" option controls start row position for data extraction.
+==== Number of rows ====
+If you need to migrate a certain number of rows, you can control it using "Start row" and "Number of rows" option to control number of exported rows.
+You can specify required number of rows for migration in "Number of rows" option. If this option is empty, all available data rows will be exported.
+==== Boolean representation ====
+This option controls the way boolean values will be converted in target database.
+Possible values “Y/N”, “T/F” or “1/0”. If set “Y/N” will be used “Y” or “N” values, if set “T/F” will be used “T” or “F” values, if this option is set to “1/0”, then “1” and “0” will be used for boolean values.
+Source database boolean representation is used by default.
+==== Divide data file into parts of ====
+If you have some restrictions or neсessity to divide the size of data files, here you can specify the size of file for data.
+Default value is 2G.
+==== Skip data export if data files already exists ====
+If you need to perform the conversion of tables with the same data set and you have already created data files, here you can switch of the re-creation of data files.
+Default value is 2G.
+\\
+If you have any other questions regarding the usage of our tool, please contact our support team: [[[email protected]]]