.SchemaEditor files

.SchemaEditor files are used to define the configuration for a particular execution of Dovetail SchemaEditor, including database connection information, schema file definition, and physical storage definitions. An example .SchemaEditor file ships with Dovetail SchemaEditor, and an example file can be generated by running Dovetail SchemaEditor with the -generate option.

This section describes the configuration file sections:

• database - Used to configure the database connection
• inputFilePath - Specifies the name of the input file. This can be either a Data Dictionary file or a Schema Script file.
• exportFilePath - Specifies the name of the schema file to be generated when performing an export operation.
• reportFile - Report file generated by preview of the differencing
• storageLocations - Used to define physical storage locations of tables and indexes
• ignoreViews - Defines certain views in the database to be ignored.

A common usage is to have one .SchemaEditor file per database. For example, one may have a development.SchemaEditor file, a test.SchemaEditor file, and a production.SchemaEditor file. Within each file is the individual database connection information, individual physical storage locations, etc.

Did this topic help you? Email us your feedback.
Last updated: 6/6/2011 5:02:37 PM
© by Dovetail Software, Inc.