Andres Jaimes

Enterprise Architect – Synchronize model from a live database

By Andres Jaimes

Synchronize a model from a live database to Enterprise Architect.

  1. Select your database from the Database Model folder in Project Browser.
  2. Go to Tools > Database Builder
  3. Right click on Tables > Show Differences. We can also click on a different type of object.
    a. An active connection is needed to complete the previous step. If no one exists Enterprise Architect will ask us to create one.
  4. The list of differences will show up on the Database Compare tab
  5. Select the ones you want to import or click the Set Import All button.
  6. The list of updates to perform will show up at the bottom of the page.
  7. Press Import from ODBC to start the process. There’s no visual feedback other than the UI becoming irresponsive during the process. Be patient.

Project browser

Database builder