Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Migration Platform
  3. Migration options
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Migration options

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

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

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

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].

Did this page help you?

Provide Feedback
PreviousTemplates
Next Task actions

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.