Using the DDL Wizard you can:

View various DDL components (or groups of components) in a neatly formatted and intuitive manner.

Create dependent object scripts. For example, the DDL for a table and all of its associated indexes, primary keys, synonyms etc can be viewed at the press of a button.

Generate drop, truncate (including foreign key disables and re-enables) or recompile scripts for any DDL object or group of objects.

Generate SQL scripts which can recreate a schema and all its DDL components.

Write the DDL out as HTML pages. The HTML pages are presented in an intuitive and interlinked tree structure that can be accessed by any web browser.

Easily strip storage clause and tablespace information from table and index DDL.

Create rule files which can manipulate the DDL in a consistent and reproducible manner.

The DDL Wizard does not require access to the Oracle database. It reads a standard Oracle export file (created with the ROWS=N option) and processes the contents. Once the export file is loaded, the database DDL is easily accessible via an intuitive user interface.

The DDL Wizard is one component in a suite of commercial applications produced by Net 2000 Ltd. which build and maintain Oracle test and development databases. Due to its general usefulness the DDL Wizard is available free of charge as a standalone utility. Other Net 2000 software tools are:

DataBee

Software which creates referentially correct database subsets for use as test and development platforms.

The Data Masker

Software which replaces sensitive production information in test databases with realistic but unrelated data of a similar type.

Key Features

The DDL Wizard Key Features Page

Online Tutorials

Main DDL Wizard Tutorials Page

Summary pages

Other Useful Software from Net 2000 Ltd.

The DDL Wizard Home Page

DDL Wizard Manual

General Topics

The DDL Wizard Application

Major DDL Wizard Application Components

The DDL Wizard Object Rules Tab

The DDL Wizard Misc. Setup Tab

Misc. DDL Wizard Application Components

The DDL Wizard Schemas & Objects Tab

The DDL Wizard Rule Information Dialog Box

The DDL Wizard Update/Add Rule Dialog Box

The DDL Wizard Find Dependency Dialog Box

The DDL Wizard DDL Source Dialog Box

The DDL Wizard Custom Rule Apply Dialog Box