Import the database schema

Topic updated 12-6-2007

Connect to your database ArrowLeft

ArrowRight Save the Database Repository

When the Datastore added in the previous step has been connected to your database, it must import the database schema, filling it with metadata about your database's tables, views, relations, etc.

method 1
If the connection to your database has succeeded a new Action Balloon appears, asking to import the database schema. Click on the Execute link:

main_buidfirstapp-07

 

method 2
The database import task will also be available from the Actions Pane when the Action Balloon has been closed or has disappeared by itself. Double click the action to activate it.

main_buidfirstapp-08

 

First the Datastore will retrieve database schema information from your database. This may take a while, just wait for the progressbar to finish.

main_buidfirstapp-09

 

When all database schema information has been retrieved, a list of tables and views is displayed. Here you can make a selection which tables and views you want to use. Tables and views that are irrelevant to your project should remain unselected here.

main_buidfirstapp-10

 

You can apply automatic selections using the Select menu.

main_buidfirstapp-11

 

When you're done making your selection of tables and views click the import button.

main_buidfirstapp-12

 

Metadata of the selected tables and views is now imported and will be kept in your Database Repository so it can be used in your GenWise project. The Project Explorer shows all the database objects for which metadata has been imported.

main_buidfirstapp-13