Schema Publication

From DBArtisan
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

The Schema Publication Wizard lets you generate HTML reports documenting the details of your schema, databases, and objects, which you can share over an intranet or the Internet. DBArtisan uses HTML Templates to create the reports which you can manually edit to create customized reports.

Schema publication produces a two-pane report. The left-hand pane lets you navigate through all objects contained in the report while the right-hand pane shows details for an individual object. THe following example shows a report on three Microsoft SQL Server default objects, displaying details for a default named UTDS.DefaultObject.


The Schema Publication Wizard lets you:

  • Generate reports for all or any level of your database.
  • View, find, and print the HTML reports directly in DBArtisan with the built-in HTML browser.
  • Create a new schema publication operation.
  • Re-use a previously defined schema publication operation.
  • Select a datasource for which you want to generate an HTML report.
  • Select the server object type and database object type for which you want to publish a schema report and lets you customize the report.
  • Select specific objects and to set certain script options for each object type.
  • Specify the report directory, HTML file name, and report title.
  • Save the schema publication operation for re-use.
  • Preview the definition of your schema publication operation.

Platform Availability


To create a schema report

  1. Connect to the datasource for which you want to produce a schema report. For details, see Connecting to Datasources.
  2. On the Utilities menu, select Schema Publication.
  3. Use the following table as a guide to understanding and setting options in the wizard:
Panel Tasks and Settings Description


Perform new publication

Select to define a new schema publication operation.

Playback an existing publication

Lets you enable use of a previously defined publication operation and provide the path and file name of the operation.


Lets you select the datasource to be published.

Catalogs (SQL Server, MySQL, and Sybase ASE datasources only)

Lets you select the target database.

Object Selection


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 and database object types that will be published.


As you select types from the Object Types list, an entry corresponding to that type is added to the Objects list. To publish only specific objects of that type, expand the list for that type and select the check boxes corresponding to the objects you want to publish.


This panel presents a visual summary of your selections and offers the following options:

Output script to file

Lets you specify the name and path of a file to store the output script.

Save existing operation

Lets you save a copy the choices you made on the wizard panels. On subsequent publications, you can then playback the saved settings, optionally changing specific option settings. You specify the path and name of the file in which to save the migration operation.

Append date and timestamp to output file name and Save output file in date specific folders

Lets you store and name output files using time and date elements.

Click Finish when ready to proceed with the extraction.


Displays a real-time status of the operation and a summary of the results.