Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

DBMS Product Conversion for a Package

The DBMS Package procedure or mapper enables you to automatically convert a package of database tables from one supported DBMS type to another supported DBMS type, as well as providing the ability to change the ownership of the tables.

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 ensure that the mapping of datatypes from one DBMS type to the other has been defined.

Access    Project Browser Package context menu | Code Engineering | Reset DBMS Options

Reference

On the Manage DBMS Options dialog map the DBMS data types of a package to the data types of another DBMS type, as indicated below:

Field/Button

Action

See also

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.

 

 

Convert DBMS Type

Select the checkbox.

 

 

Process Child Packages

If there are child packages that also require changing, select the  checkbox.

 

 

OK

Click on this button to map all tables in the selected packages to the new DBMS.

 

 

 

Also on the Manage DBMS Options dialog, you can change the owner of the selected table or all of the tables in a package, as indicated below:

Field/Button

Action

See also

New Owner

Type the name of the new table owner.

 

 

Current Owner

Click on the drop-down arrow and select either:

The current owner to change, or
<All> to change the ownership of all tables in the package to the name you typed in the New Owner field

 

 

Change Table Owner

Select the checkbox.

 

 

Process Child Packages

If there are child packages that also require changing, select the checkbox.

 

 

OK

Click on this button to change the ownership of the selected Table, or all Tables in the selected packages that have the specified current owner.

 

 

Learn more