Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:data-migrator [October 22, 2018, 01:58:43 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:data-migrator [May 03, 2019, 11:14:33 AM] (current)
darya.prikhodkina
Line 1: Line 1:
 \\ \\
 [[http://www.ispirer.com|Ispirer Home Page]] [[http://www.ispirer.com|Ispirer Home Page]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]] +[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]]
 \\ \\
 ====== Sqlways.ini File - Section [DATA_MIGRATOR] ====== ====== Sqlways.ini File - Section [DATA_MIGRATOR] ======
  
-On this page described options that can be used to work with On The Fly Data Migration tool.+This article describes the options that can be used when working 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. +Please also 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  ^  ^  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". | +| **USE_DATA_MIGRATION_TOOL** | This option defines if 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 Migratortool.  \\ Possible values - "Yes", "No". Default value - "No". | +| **BIN_DIRECTORY_DATA_MIGRATOR** | In this option we need to provide a path to 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_PREFETCHED** | This 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.  |+| **NBR_OF_ROWS_LOADED_PER_INSERT** | This option defines the number of rows, that will be inserted into the target database within one insert statement.  |
 | **COMMIT_SIZE** | Defines commit size.  | | **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".  | | **TRUNCATE_TARGET_TABLES** | Defines whether the target tables should be truncated or not. \\ Possible values - "Yes", "No". \\ Default value - "No".  |
Line 21: Line 21:
 | **DISABLE_CONSTRAINTS** | Defines whether to disable constraints 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. | | **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. | +| **TRACE_LEVEL** | Defines the trace level from 0 to 4. The greater number is specified, the 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". |+| **TABLE_LIST_FILE** | Path to the file with the list of tables, that should be migrated using On The Fly Data Migrator. |
  
  
Line 32: Line 32:
 \\ \\
  
-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: **__[[[email protected]]]__**+If you have any questions about the supported options or any features that you may need during your migration project, please contact our technical team: **__[[[email protected]]]__**
  
 \\ \\
 [[http://www.ispirer.com|Ispirer Home Page]] [[http://www.ispirer.com|Ispirer Home Page]]
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]] +[[http://www.ispirer.com/products|Ispirer MnMTK Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request Ispirer MnMTK]] 
sqlways/command-line/sqlways-ini/data-migrator.txt · Last modified: May 03, 2019, 11:14:33 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement