Map Data Types Between DBMS Products

One of the advantages of using visual physical data models to hide implementation details is that you can more easily change the target technology or platform when required.

After reverse engineering your database into a physical data model, you must remap the data types before generating the schema for the new DBMS product. Enterprise Architect provides a set of default mappings for standard, supported DBMS products, to help you automate the conversion process.

However, you might want to customize the default mappings to suit your specific project requirements, or where the mapping of one data type to another is not currently defined. For example, in your migration from one DBMS platform to another, one of the platforms might be non-standard or otherwise not supported by Enterprise Architect.

Access     Settings | Database Datatypes: Datatype Map

Use to

Streamline conversion of one implementation-specific database product to another
Map data types from one DBMS product to another
Maximize portability of your database designs
Customize default mappings


On the Database Datatypes Mapping dialog, map the data types between databases as indicated below:



See also

From Product Name

Click on the drop-down arrow and select the DBMS product to map data types from.



Defined Datatypes for Databases

Displays all the defined data types for the product and, where appropriate, their sizes and values.

Click on the data type to map - this must have a defined size unit and value.

The Datatype and Common Type fields under the From Product Name field display this data type.



To Product Name

Click on the drop-down arrow and select the DBMS product to map data types to.

The Datatype and Common Type fields under this field display the values corresponding to those in the fields for the 'From' product.




Click on the radio button for the appropriate size unit and type the default values in the corresponding data fields.




Click on this button to save the mapping.



Repeat this process for all the data types to map.

Once you are satisfied with the data type mappings, you can convert either individual tables or an entire package of tables to the new target DBMS product.

Learn more

Learning Center topics

(Alt + F1) | Database Engineering | Physical Data Model | DBMS Migration