Sqlways.ini File - Section [DATA_MIGRATOR]

On this page described options that can be used to work with On The Fly Data Migration tool.

Also please note, that On The Fly Data Migration Tool is an additional tool that allows to migrate data directly from one database to another. Without saving information in files on your local machine.

Option name	Description
USE_DATA_MIGRATION_TOOL	This option defines if the On The Fly Data Migrator tool will be used in current migration process. Possible values - “Yes”, “No”. Default value - “No”.
BIN_DIRECTORY_DATA_MIGRATOR	In this option we need to provide a path to the “On the Fly Data Migrator” tool. Possible values - “Yes”, “No”. Default value - “No”.
NBR_OF_ROWS_PREFETCHED	Option defines the number of prefetched rows.
NBR_OF_ROWS_LOADED_PER_INSERT	Defined the number of rows, that will be inserted into target database within one insert statement.
COMMIT_SIZE	Defines commit size.
TRUNCATE_TARGET_TABLES	Defines whether the target tables should be truncated or not. Possible values - “Yes”, “No”. Default value - “No”.
DISABLE_TRIGGERS	Defines whether to disable triggers before loading the data into the target database. Possible values - “Yes”, “No”. Default value - “Yes”.
DISABLE_CONSTRAINTS	Defines whether to disable constraints before loading the data into the target database. Possible values - “Yes”, “No”. Default value - “Yes”.
TENCODING	Defines table encoding.
TRACE_LEVEL	Defines the trace level from 0 to 4. The greater number is specified, more information will be saved in the trace file.
TABLE_LIST_FILE	Path to the file with the list of tables, that should be migrated using the “On The Fly Data Migrator”.

Example:

[DATA_MIGRATOR]
USE_DATA_MIGRATION_TOOL=Yes

If you have any questions about the supported options or some features that you may need during your migration project, please contact our technical team: support@ispirer.com

Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays