Ispirer Website Ispirer Toolkit Overview Free Trial

General

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

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.

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.

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.

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.

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.

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