Incorporating changes made with entity-relationship modeling tools into Optim Database Administrator

You can incorporate changes that were made with entity-relationship modeling (ERM) tools into Optim™ Database Administrator.

Procedure

To incorporate changes made with ERMs, complete the following steps:

  1. Forward engineer the DDL from the ERM tool.
  2. Create a new change management script. In the Administration Explorer, right-click the Change Management Scripts folder under the database connection to which you want to migrate changes, and select New database change. A new change management script is displayed in the Change Management Script Editor.
  3. On the main menu toolbar, select Change Management > Compare and Migrate Objects. The Change Management Script Editor view that displays the change management script must be active to select Compare and Migrate Objects.
  4. Complete the Migrate Objects to Target Model wizard. Use the DDL that you forward-engineered from your ERM tool as your migration source.

Feedback