Import Database Schema

1

Select a Package in the Project Browser, into which to import the database schema.

Create a database modeling diagram in this Package.

Create a Data Model Diagram

2

To import, either:

The Import DB Schema from ODBC Source dialog displays.

3

In the Database field, click on the ( ...  )  (Browse) button and, on the Machine Data Source tab of the ODBC Select Data Source dialog, click on the required data source name and then click on the OK button (ODBC must be installed and configured on your machine for this to work correctly).

When you have selected the data source, the Database field shows the DBMS, the database server ID and the database name, separated by full stops; that is:

          dbms.dbserver.database.

See Notes below, concerning 32-bit ODBC drivers

4

You can filter objects to be retrieved from the database by schema (where the database type supports multiple schemas, such as SQL Server 2005/2008/2012, Oracle, PostgreSQL and DB2 Express). The available schemas are automatically listed in the Only include objects from Schema(s) panel.

Click on the checkbox against each schema to import. Click on the All button to select all the schemas, or the None button to clear all selected checkboxes.

If you suspect that the schema might have changed since you loaded them, you can refresh the list by clicking on the Reload Schemas button.

By default, when importing database objects from Oracle, Enterprise Architect inserts the Oracle user name against each schema to avoid unnecessary retrieval of large numbers of objects not owned by a specific user.

5

Select the appropriate checkboxes to import:

Database Tables

Database Views

Table Triggers

Oracle Packages

6

Select the appropriate checkboxes to import:

Each database Procedure, Function or Sequence can be imported either as a Class or as a set of operations contained under a Class; select the appropriate radio button for each object type.

Import as individual Classes

The script is imported into separate Classes. The Properties dialog for each of these Classes supports a context sensitive editor for editing the script.

Import as Operations

The selected items are imported to a single Class as Operations (methods); you can view and edit them through the Operations Properties dialog of the parent Class.

Database Procedures

Database Functions

Database Sequences

7

In the Synchronization panel, select the appropriate radio button to indicate whether the existing Classes are to be updated, or the database objects imported as new objects.

If you select the Synchronize existing classes option, also select the appropriate checkboxes to determine whether model comments, column default values and/or Table constraints are to be retained or overwritten with the comments, values and constraints of the imported objects.

See Notes below, concerning SQLite Table and column comments

8

In the Import To... panel, select the appropriate radio button to indicate whether to update the Package and currently-open data model diagrams, or just the Package.

If no diagrams are open, the Package Only radio button defaults to selected and the options are disabled; if the open diagrams are in the selected Package, you can select either option.

9

Click on the Import button to start the import.

The Select Database Objects to Import dialog displays, listing the database objects available in the source database or in the schema selected in the Import DB Schema from ODBC Source dialog.

Select the checkbox for the database or each schema, and for each database object type and object to import.

Click on the All button to select all types and objects, or on the None button to clear all selected checkboxes.

When you have selected all the objects to import, click on the OK button to resume the import.

The Imported Class Elements