Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

DDL and Data Options - Data Options/General Combobox

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
Use Ispirer On the Fly Data Migrator Specifies whether or not to migrate the data without storing it on PC

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.

Use Ispirer On the Fly Data Migrator

Also you can use the “Use Ispirer On The Fly Data Migrator” option to specify whether or not to migrate the data directly from one database to another database, bypassing the export data into files. This allows hasten the data migration process between the databases. Settings for On The Fly Data Migrator need to be specified on the Advanced page.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/specify-ddl-data/table_options/data_options/general.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement