Using the Schema Extraction Wizard

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.