Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Manage DBMS Options

Using the 'Manage DBMS Options' dialog, you can quickly change the DBMS Type and/or Owner of an individual database object or several objects within an individual Package or Package hierarchy. You can also create bulk Foreign Key Indexes on all Foreign Keys that do not already have an index.

Access Project Browser | Right-click on Package | Code Engineering | Reset DBMS Options

Convert DBMS Type

Field/Option/Button

Action

See also

Convert DBMS Type

Select this checkbox if you want to change the DBMS type.

Current DBMS

Click on the drop-down arrow and select the current DBMS type.

This field can default to the commonest DBMS type detected.

New DBMS

Click on the drop-down arrow and select the DBMS type to convert to.

Process Child Packages

Select this checkbox to include all the database objects in all sub-Packages.  Checking or unchecking this control will immediately refresh the list of objects.

OK

Click on this button to replace all database objects of the old DBMS type to those of the new  DBMS type.

When performing this function, the data types of all Table columns are automatically converted to the closest match for the selected DBMS; therefore, you should perform a manual review after running the process.

Change Table Owner

Field/Option/Button

Action

See also

Change Table Owner

Select this checkbox if you want to change the database object owner.

Current Owner

Click on the drop-down arrow and select either:

  • The current object owner to change, or
  • '<All>' to change the ownership of all database objects in the Package to the name you type in the 'New Owner' field

New Owner

Type the name of the new object owner.

Process Child Packages

Select this checkbox to process child Packages as well.

OK

Click on this button to change the ownership of the database objects that have the specified current owner name to the new owner name.

Create Indexes for Foreign Keys

Field/Button

Action

See also

Create Indexes on Foreign Keys

Select this checkbox to create an index on all Foreign Keys where one does not already exist. The name of each Foreign Key index created will be based on the Foreign Key Index DDL Name template.

DDL Name Templates

Process Child Packages

Select this checkbox to process child Packages as well.

OK

Click on this button to create the Foreign Key indexes.

Learn more