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.

  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, as defined on the Application Schema Modules Metadata form
    • Tables metadata, as defined on the Application Schem Tables Metadata form
    • Column (Next Keys) metadata, as defined on the Application Schema Columns Metadata form.
  3. Load the SQL scripts 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.