Table of Contents
Ispirer Website
Ispirer Toolkit Overview
Free Trial
General
Overview
| Option Name | Description |
|---|---|
| Export Data | Specifies whether or not to export the data |
| Start row | Specifies start row position for data export |
| Number of rows | Specifies how many rows should be exported |
| Boolean representation | Specifies boolean values format |
| Divide data file into parts of | Specify the size of data-files |
| Skip data export if data files already exists | Specify the necessity to re-create data files |
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: support@ispirer.com