Import Schema

Topic updated 7-6-2007

The Import Schema window is used to import metadata from your database schema into a Datastore. Metadata of the following types of database objects is imported:

Tables
Views
Columns
Relations (Primary Key and Foreign Key constraints)
Indexes

 

You can open the Import Schema window from the Project Explorer by right-clicking a Datastore node and choosing Import Schema from the context menu. When you're creating a new Database Repository an Action Balloon appears to take you to the Import Schema window for the Datastore1 that is automatically added.

The Import Schema window displays a selection screen in which you can select database entities to import.

ImportSchema

 

The select option in the menu you can be used to apply selections such as all tables or all views.

ImportSchema-Selections

The Add Related Tables option at the bottom of the window can influence the final selection of tables that will be imported. If you didn't select all tables and/or views, the Add Related Tables option will cause related entities to be imported along with the entities you selected. Entities not selected, but related to the entities you selected will be imported. You can set the amount of relation levels to which this rule should be applied. You can also turn this option off.

When your selection of entities is complete, click the Import button at the bottom of the window.

 

See also

If your database schema has been changed, use Compare Schema to synchronize your Datastore to it.