Import Database Schema

1

Open the Database Builder (Develop > Data Modeling > Database Builder)

2

Load or create a Data Model.

3

• Right-click on the loaded Data Model in the Database Builder and select 'Import DB schema'  or

• From the ribbon select 'Develop > Data Modeling > Import'

The 'Import DB Schema' dialog displays, showing the details of the current active database connection.

Database

This field shows a description of the current Live connection, in the format:

     dbms.database_server.database_name

If necessary, click on the button and, select an alternative connection.

Import to

This field shows the target Package that the new objects will be saved to.

If you want to specify a different Package, click on the button and select an alternative Package.

Only include objects from Schema(s)

If the database type supports multiple schemas (such as SQL Server, Oracle, PostgreSQL and DB2 Express) you can filter objects to be retrieved from the database by schema.

The available schemas are automatically listed in this panel. Select the checkbox against each schema to include in the import.

(You can 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 list might have changed since you loaded them, you can refresh the list by clicking on the Reload Schemas button.

Name Filter

The 'Name Filter:' field allows filtering of objects using SQL wildcards appropriate to the DBMS of the schema being imported.

For example, for Oracle:

• LIKE 'A%' - list objects with a name starting with the letter 'A'
• NOT LIKE '%\_%' ESCAPE '\' - list objects with a name that does not include an underscore (_)
• IN ('TABLE1','TABLE2') - list objects with names that are included in the parentheses
• NOT IN ('TABLE1','TABLE2') - list objects with names that are not included in the parentheses

Note that only one filter can be entered. You cannot add a second filter using the AND clause.

Filtering is not available for MS Access

Filter Options

The 'Filter Options' panel controls what object types and properties are read in from the database schema. Values changed on this screen are saved to the registry so that they are re-applied in the next work session. The available options are briefly described here; select the checkbox against an option to activate it.

Tables

• Tables - Select to import Tables
• Table Primary Keys - Select to import Primary Key definitions on Tables
• Table Foreign Keys - Select to import Foreign Key definitions on Tables
• Table Indexes - Select to import Table Indexes
• Unique Constraints - Select to import Unique Constraint definitions on Tables
• Check Constraints - Select to import Check Constraint definitions on Tables
• Table Triggers - Select to import Trigger definitions on Tables
• Table Properties - Select to import extended Table properties
• Constraint Properties - Select to import Constraint Properties for Tables
• Length Semantics - Select to import length semantic definitions on Oracle string columns

Objects

• Views - Select to import Views
• Procedures - Select to import Procedures
       - As Operations - Select to import Procedures as operations (methods) of a single Class; you can
         view and edit them through the Database object container 'Properties' dialog (the option defaults
         to unselected, where the selected items are imported as separate Classes)
• Functions - Select to import Functions
       - As Operations - Select to import Functions as operations (defaults to unselected)
• Sequences - Select to import Sequences
       - As Operations - Select to import Sequences as operations (defaults to unselected)
• Package - Select to import Oracle Packages

Advanced

• System Objects - Select to import system Tables, Views and other system objects

Warning: With the 'As Operations' option for Procedures, Functions and Sequences, if objects have been imported under one setting (selected or unselected) and then you change the setting and import further objects, the objects imported under the first setting are removed.

Synchronization

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.

Import To

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.

Import

Click on this button to start the import.

The 'Select Database Objects to Import' dialog displays, listing all the database objects found that match the selection criteria.

Select the checkbox against each schema (or object type) to automatically select all objects in that group or to import each object individually.

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 continue the import.