DBMS Product Conversion for a Package

Using the DBMS Package mapper, you can automatically convert a Package of database Tables from one supported DBMS type to another supported DBMS type. You can also change the DBMS type for individual Tables.

If one of the DBMS types is non-standard or otherwise not supported by Enterprise Architect, you should check that the mapping of datatypes from one DBMS type to the other has been defined.

Access

Ribbon

Code > Schema > DDL > Open the Database Builder or

Specialize > Tools > Database Builder

Then:

Right-click on the required database | Load | right-click on the root node | Manage DBMS Options

Map the DBMS data types of a Package to the data types of another DBMS

Field/Button	Action	See also
Include Objects in Child Packages	If there are objects in child Packages that also require changing, select the checkbox.
Change DBMS	Select the checkbox.
Current DBMS	Click on the drop-down arrow and select the current DBMS.
New DBMS	Click on the drop-down arrow and select the target DBMS.
OK	Click on this button to map all Tables in the selected Packages to the new DBMS.

Learn more