Schema Publication

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

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

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
Playback	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.
Connection	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	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 and database object types that will be published.
	Objects	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.
Summary	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.
Execute	Displays a real-time status of the operation and a summary of the results.