Migration options
You can get more detailed information on the migration settings of a particular table in the Set migration options window. To invoke this window right-click at the table on the Source side (Figure 1) and select the Set Migration options option from the context menu.
Figure 1. Invoke Set migration options form
Columns tab
Figure 2. Data migration options. Columns tab
In this tab, you can (refer to Figure 2):
- Exclude columns from migration by set/unset checkboxes;
- Set custom transformation for the Source column before migration to the Target side.
Note 1: Exclude columns and Custom transformation are provided by the Column mapping options form that has the same logic. Mind that settings in the Column mapping options form have a higher priority.
Note 2: Syntax correctness in the Custom transformation field is not checked.
Filter tab
Figure 3. Data migration options. Filter tab
The filter allows you to migrate not the whole table, but only its part ignoring obsolete data (Figure 3).
Note: Syntax correctness is not checked in the filter.
Virtual partitions tab
For accelerating the migration of large tables, DB Best Migration Platform provides the ability to split each table into several segments using filtering conditions, and create migration subtasks for each segment. This allows you to migrate multiple segments simultaneously in a parallel thread (Figure 4).
Figure 4. Data migration options. Virtual partitions tab
The types of virtual partitions (Figure 5) are the following:
- Automatic;
- Using additional defined parameters;
- Custom. List;
- Custom. Ranges;
- Custom. Custom Filters.
Figure 5. Partitioning mode
Automatic partitioning mode
Figure 6. Automatic partitioning mode
Automatic partitioning allows you to automatically split the table into partitions. If you enable auto-splitting for the table, this mechanism will pre-evaluate the table, determine the optimal number of virtual partitions, and create the necessary migration subtasks (Figure 6).
Note: Automatic partitioning works for tables with over 10.000 rows.
Figure 7. Task example with Automatic partitioning mode
Automatic partitioning mode using defined parameters
Figure 8. Automatic partitioning mode using defined parameters
For this type of partitioning (Figure 8), you can set the following options:
- Create partitions by column: selection of the column where the partitioning will occur; Combobox contains only columns with a number (int, bigint, decimal, float, etc.) or date time (date, timestamp, etc.) type; columns which are the only columns in index are marked with *, columns of a multicolumn index are marked with **;
- “Max partition count”: maximum number of partitions;
- “Max number of rows in extracted file”: maximum number of rows.
Figure 9. Task example with Automatic partitioning mode using defined parameters
Custom partitioning: List
Figure 10. Custom partitioning: List
For this type of partitioning (Figure 10), you can set the following options:
- Create partitions by column: selection of the column where the partitioning will occur; Combobox contains only columns with a number (int, bigint, decimal, float, etc.) or date time (date, timestamp, etc.) type; columns marked with ** have the best conditions for partitioning;
- Add button: used to invoke a form for an added list of value to the Key set (Figure 11);
- Key set: grid displays the key set of values;
- Create a separate partition for NULL values: a checkbox for creating a separate partition for NULL values;
- Create a separate partition for values not contained in the list: a checkbox for creating a separate partition for values not contained in the list.
Figure 11. Add virtual partition list values
Custom partitioning: Range
Figure 13. Custom partitioning: Range
For this type of partitioning (Figure 13), you can set the following options:
- Create partitions by column: selection of the column where the partitioning will occur; Combobox contains only columns with a number (int, bigint, decimal, float, etc.) or date time (date, timestamp, etc.) type; columns marked with ** have the best conditions for partitioning;
- Add button: used for adding value to the Range points list;
- Range points: a grid that displays a range of points;
- Create a separate partition for NULL values: a checkbox for creating a separate partition for NULL values.
Custom partitioning: Custom filters
Figure 15. Custom partitioning: Custom filters
For this type of partitioning (Figure 15), you can set the following options:
- Field for entering a filter value;
- Add button: used for adding value to the conditions list;
- Import button: used for importing conditions from a .csv file.
Note: Syntax correctness is not checked in the filter.
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].