Update the Clarify Schema

You can change the Clarify schema with either Dovetail's SchemaEditor or Clarify's DDEditor.

Prior to making schema changes, backup the current database.

To make these changes using Dovetail SchemaEditor:

  1. Edit the .SchemaEditor file
  2. Preview the changes (SchemaEditor.exe -p).
  3. Apply the changes (SchemaEditor.exe -a).


To make these changes using Clarify DDEditor:

  1. Start the DD Editor program.
  2. To save a copy of the database schema to disk, select Save.
  3. Edit the saved schema file.
  4. Edit the dovetail_admin_schema.sch file. Follow the directions in that file to cut/paste the schema changes into the saved schema file. Use the Apply Changes menu item to compile the new saved schema file.
  5. Exit DD Editor.

See Also

Installing Dovetail Admin

Install the Dovetail SDK

Set Configuration Items

Import the Data Files

Configure the Web Server

Edit the fc.env File

Test the Connection

Grant Permissions

Add Performance Indexes

Next

Set Configuration Items

Update the Clarify Schema