Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Data types mapping
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

Data types mapping

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

Data types mapping tab in the Mapping module shows how data types are connected inside of the database.

DB Best Migration Platform supports 3 types of data types mapping:

  • Default mapping — the basic mapping used in Schema Comparison. Default mapping doesn’t support adding or deleting pairs, so you can only edit the Target. DB Best Migration Platform starts default mapping when the schema comparison has no mapping set (such as Columns or Arguments).
  • Columns  — the mapping type used in Schema Comparison for all data types in columns.
  • Arguments — the mapping type used in Schema Comparison for ALL (In/Out/Return) parameters, functions/procedures.
  • Local Variables & Return values —  the mapping types available only in Oracle. For now, they are not involved in the DB Best Migration Platform operations.

Operations on the data types mapping

You can add, edit, reset, delete and import the mapping types.

Adding pairs

To add a new pair of datatypes to the types of mapping follow these steps:

  1. Click the Add button in the bottom menu (Figure 1). Note: The button can be disabled if you select the default mapping type.
v

Figure 1. Add button

  1. In the newly opened window (Figure 2) set a new pair of data types you want to map.
Figure 2. Add new mapping window

Figure 2. Add new mapping window

  1. Click the Apply button.

Edit

To edit a pair of datatypes in type mapping follow these steps:

  1. Click the Pencil button (Figure 3).
Figure 3. Edit button

Figure 3. Edit button

  1. Edit the existing pair datatypes in the opened window.
  2. Click the Apply button.

Note: In the Default type of data type mapping you can edit the Target side only.

Delete

To delete a pair, click the basket button in front of the pair (Figure 4). The button is invisible for the Default type mapping.

Figure 4. Delete button

Figure 4. Delete button

Import

DB Best Migration platform allows for importing the SSMA type mappings.

When importing, the system operates three main principles:

  1. Old mappings are not deleted. New mappings are added to the existing ones.
  2. If the new mapping duplicates already existing it won’t be added.
  3. Mapping gets added to Default mapping. For the pair of Oracle — MSSQL, the mapping will be added to the special mapping category (Local variable, Return values, Columns, Arguments) and not default.

To import pairs in type mapping follow these steps:

  1. Click the Import button in the bottom menu (Figure 5).
  2. In the opened window click the Select button and choose a file (*.mappings) to import.
  3. Click Import to finish.
Figure 5. Import button

Figure 5. Import button

Note: You can import only the SSMA type mappings (Oracle – MSSQL, MySQL – MSSQL, Sybase ASE – MSSQL). If the Select button is disabled, the Conversion System is not SSMA.

Reset

To reset the mapping of the data types, click the Reset button (Figure 6).

Note: You cannot roll back this operation.

Figure 6. Reset button

Figure 6. Reset button

Example type pairs

For example, we have two columns with datatype Char(100).
If the mapping type doesn’t contain a pair having Char(100) at Source and Target, then the Schema Comparison will show data type not equal.
Examples of valid pairs:

  • Char(1..300) – Char(1…200)
  • Char(100) – Char(1…200)
  • Char(1…100) – Char(100)
  • Char(100) – Char(100)

Examples of the invalid pairs:

  • Char(1..300) – Char(101…200)
  • Char(99) – Char(1…200)
  • Char(100) – Char(85)

Note: DB Best migration platform considers the data types with parameters such as Length/Precision/Scale and without the parameters to be different data types.

Example:

Char is not equal to Char(Length).


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
PreviousObject mapping
Next Schema conversion

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.