Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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 Project | Settings | Database Datatypes: Datatype Map
Map Data Types
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.
|
|
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) | Enterprise Architect | Database Engineering | Physical Data Model | DBMS Migration |
