Create a New Project From a Database

From DBArtisan
Jump to: navigation, search

Go Up to Create a New Project

A context-sensitive wizard reverse-engineers all or part of an existing database. It lets you create a project containing files based on the relevant object types. A separate file is created for each database object.

Reverse engineering is a powerful tool for analyzing, controlling, and documenting existing database objects. You can use the extracted SQL source code for archival and reference purposes.

Note: The project script file build order is automatically discovered and set by referencing the system catalog to determine dependencies.

To start a new project from a database

  1. Select File > New > Project. The New Project dialog box opens.
  2. Complete the New Project dialog box, ensuring you select the From Database option, and then click OK. The Reverse Engineer Wizard opens.
  3. Use the following table as a guide to understanding and setting options in the wizard:
Panel Tasks and Settings Description

Connection

Source Datasource

Lets you select the datasource for which you want to start a project..

Catalogs (only displayed for multiple database DBMS datasources)

Source Database

Lets you select one or more databases for which you want to start a project..

Object Selection

Schemas

Opens a dialog that lets you narrow the choice of candidate objects by selecting only those associated with specified schema/owners.

Object Types

Lets you select the object types that will be extracted. You can use the expand/collapse icons to hide and show the dependent object types for each object. As you select object types, all objects of that type (that satisfy the Schemas criteria) are made available for selection in the Objects list. Selected dependent object types are also made available in the Objects list. For information on setting the dependent object type automatically selected to be extracted along with each object type, see DDL Extract Options.

Objects

Lets you select the specific objects that will be extracted. For each object selected, you can also select the specific dependent objects that are to be extracted.

Options

This panel lets you choose extraction options and view an Example Preview script that is updated as you choose options. It also lets you save your options choices as a template, with an option to use the saved template as the default. Click Finish when ready to proceed with the extraction.

Execute

Displays the status of the extraction with details on the number of objects retrieved, the number of errors detected, and the elapsed time. On completion, the schema definition is stored in the file you specified on the previous panel. Filter options (Show All, Show Errors, and Show Warnings) let you display specific types of messages generated during the extraction process. When the extraction completes, you can also use the following options:

Continue

Adds the individual files for each obect to the project.

Report

Opens a detailed report on the results of the schema extraction.