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:
|
|
||||
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