Building and running application schema metadata scripts

You can dump the metadata into SQL scripts which can then be loaded into other application databases, for example at other sites where the same table/column changes are being made.

Follow these steps:

  1. In one site, define the metadata as described above.
  2. Use the Generate Application Schema Metadata Scripts form to create these scripts, as needed:
    • Module metadata, which was defined in the Application Schema Modules Metadata form
    • Tables metadata, which was defined in the Application Schem Tables Metadata form
    • Column (Next Keys) metadata, which was defined in the Application Schema Columns Metadata form.
  3. Load the SQL script(s) into other sites (application databases), which must also contain any applicable new or modified schema elements.
  4. At these other sites, use the Trigger Management form to generate triggers for specified tables.