Using the Schema Extraction Wizard

From DBArtisan
Jump to: navigation, search

Go Up to Schema Extraction and Migration

The Schema Extraction wizard walks you through the process of building an extraction script, executing it for storage of the database or object schema in a file. The basic process includes choosing the server and database objects for extractions and specifying options that dictate how the extraction script is built. This utility allows you to:

  • Extract and archive entire databases or sets of database objects.
  • Generate the complete definition of any database object type.
  • Reverse-engineer schema, and also place the SQL statements in their proper sequence, regardless of the objects you select.
  • Create a new schema extraction operation.
  • Reuse a previously defined schema extraction operation.
  • Specify the target object types to extract.
  • Specify the dependent object types automatically extracted for any object type.
  • Set the general script type and options.
  • Preview the definition of your schema extraction operation.


Platform Availability

DB2 LUW DB2 z/OS ORCL PSTGRS * SQL SVR SYB ASE SYB IQ



To build and execute a schema extraction script

  1. Connect to the datasource where you want to extract schema. For details, see Connecting to Datasources.
  2. On the Datasource Navigator/Explorer select the target database or database object.
  3. On the Utilities menu, select Schema Extraction. The Extraction Wizard opens.
  4. Use the following table as a guide to understanding and setting options in the wizard:
Panel Tasks and Settings Description

Playback

Perform new extraction and Playback an existing extraction

Lets you start a new extraction or select an existing extraction script you want to replay from the drop-down list. NOTE: When the script opens, you can make changes to the operation you are replaying. The changes you make will overwrite the current script.

Connection

Source Datasource

Lets you select the datasource from which you want to extract schema.

Catalogs (only displayed for multiple database DBMS datasources)

Source Database

Lets you select one or more databases from which you want to extract schema.

Object Selection

Schemas

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

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 migration/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. For a detailed descriptions of the options presented on this panel, see Common Schema Migration and Extraction Options.

Summary

Presents the following options:

Output script to file

Lets you output the script performing the extraction to a file with the specified path and name.

Save existing operation

Lets you save a copy the choices you made on the wizard panels. On subsequent schema extractions, you can then playback the existing extraction, optionally changing option settings, in creating an extraction script. You specify the path and name of the file in which to save the extraction operation.

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

Opens the extraction script in the ISQL Editor. For more information, see Coding Environments/Editors.

Report

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