The Rule Controller maintains the schema structure information (tables, indexes, foreign keys and triggers) for the set rules as well as the login and connection information. The schema structure is not refreshed each time a connection is made as this would take a considerable amount of time. Tables and other schema items can also be removed in the extraction set if they are specifically excluded from the set using the tools on the Tables in Set tab.
This means that the schema structure known to the extraction and loader sets can be different to the actual structure contained within the database. The schema structure held in the Rule Controller can easily be updated using the buttons on the Tools tab of the Edit Rule Controller form. Just double click with the mouse on any Rule Controller to access these tools.
Refreshing the schema structure will ensure that the schema information known to the Rule Controller is identical to that in the actual database - however the refresh operation does not provide any indication of the differences and changes that have happened. This information may be important in adjusting the rules to work with the new server side schema.
The Schema Comparison tool is designed to compare the schema structure stored in the Rule Controller with the real structure in the schema to which the Rule Controller connects. The output of the tool is a very readable report which details the changes.
The Schema Comparison Tool Form
The Schema Comparison Tool is quite easy to use and the button to launch it can be found on the Tools tab of the Data Masker main form. The tool only compares the schema for a single Rule Controller at a time. If more than one Rule Controller is present in the set, you will be prompted to choose the Rule Controller you wish to check.
The Compare Options panel at the top right contains a button entitled Connect and Compare and the options above it provide the choice of schema item types to compare. The options in the Display Filters panel on the bottom right hand side determine the items displayed in the right hand panel. Changing these items does not cause a new comparison to be made - these options simply add or remove items from the report on the right hand side to make it more readable.
What the Compare Options do
What the Display Options do