Importing Offline Database Definitions Using Import with Filters

You can import tables and views from a database schema to an offline schema where they become available as offline database definitions. You can apply filters in the wizard to only display the objects you are interested in, and when there are a large number of objects in the schema you can turn off auto-query so that the wizard does not refresh every time you type a filter character.

To import tables and views:

In the navigator, expand the workspace and project you want to work in.
Right-click a schema, or anything in it, and select New to display the New Gallery.
From the New Gallery, expand Database Tier , and select Offline Database.
Choose Offline Database Objects Imported from Database to launch the Import Offline Database Objects wizard.
In the pages of the wizard enter parameters and select options to select the objects to import. For information about how to fill these in values, click Help in the dialog.
You can apply filters to select the objects that are displayed as available for import. In the Select Objects page, you can:
- Enter characters in Name Filter to filter the list of available tables and views by name. When there are a large number of objects, you can turn off Auto-Query, and click Query once you have entered the filter you want to use.
- Select the Object Types to view just tables, views or both.
Click Next.
Click Finish to import the tables and views.

Context Menu Shortcut:

In the navigator, right-click the offline schema and select Import Database Objects.