Database Refresh Wizard

Applying Additions

The Database Refresh Wizard displays new table and column additions to your database and gives you the option to click and drag the new tables into each Database Schema that references that Data Source. The new tables and contained columns will be available as nodes in the updated Schemas.

You can drag a new table to place it within a Schema, within a different table, or within itself (a like-named table). If you place a new table within a like-named table, Clarify will add a suffix to the name, as table names must be unique.

When a table is added to a Schema, all its columns are automatically added as well. Those tables and columns are then available in any Rulesets that reference the updated Schemas.

By extension, Database Adapters that reference those Schemas will automatically be updated. Clarify will add new tables to the Database Adapters' Data Bindings section. It will not add the new table to any Interactions.

Applying Edits

The Wizard displays edits, such as column data types and lengths, and automatically applies them to your Schemas. There is no need to click and drag to apply edits to Schemas.

An edit icon on a table signifies that a column within it has changed.

Applying Renames

The Wizard displays renamed tables and columns as deletions and additions. You must select (Control+click) both tables (original and renamed) and click the Rename Table/Column button to instruct Clarify to treat them as a rename. Once you do, any column additions, deletions, or edits are displayed beneath the renamed table. Select any other embedded renamed columns one pair at a time and press the Rename button to apply further renames.

The Wizard applies renames to the Data Source. It applies table renames to the Data Bindings section of Database Adapters, but does not change any existing Interactions.

The Wizard does not apply the rename to Schemas. Although the rename is not reflected in the Schema and Ruleset, all Rules will continue to function correctly.

Applying Deletions

If the Wizard detects a deletion, it will remove the table or column from the Data Source. Clarify also removes the table from the Database Adapter's Data Bindings section and removes any references to them from the Interactions. If an interaction only has one binding, and that binding has been deleted, the entire interaction will be deleted.

The Database Refresh Wizard will not give you the option to delete a table or column from any Schemas.

Therefore, when deleting from a Data Source, if you want the corresponding tables or columns deleted from the Database Schema and dependent Rulesets, you must open the editors and do it manually.

In Summary