Map Data Types between DBMS products

One of the advantages of using visual models to hide implementation details is that you can more easily change the target technology or platform when required. Enterprise Architect provides tools such as Datatype Mapping to help you do this for physical data models. For example, your project might involve migration from one DBMS platform to another.

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 to help you automate the conversion process. However, you might want to customize the default mappings to suit your specific project requirements.

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

How To:

To map data type sizes between databases, follow the steps below:



See Also


In the From Product Name field, click on the drop-down arrow and select the DBMS product to map data types from

The Defined Datatypes for Databases panel 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



In the To Product Name field, 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 corresponding values to those in the fields for the 'From' product



In the Size panel, click on the radio button for the appropriate size unit and type the default values in the corresponding data fields



Click on the Save button to save the mapping.


You can repeat this process for all the data types you want to map.

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