Map Data Types Between DBMS Products

Whilst modeling physical data models provides a great deal of detail about all Tables and their columns, this level of detail does make it harder to change the target technology or platform. For example, 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

Ribbon

Configure > Reference Data > Settings > Database Datatypes : Datatype Map

Database Data Types Mapping

Repeat this process for each of 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.

Field/Button	Action	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.
Size	Click on the radio button for the appropriate size unit and type the default values in the corresponding data fields.
Save	Click on this button to save the mapping.

Learn more