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.

The document Insert and Update Trigger Generation explains in much greater detail the specifics of this metadata and its use in the system.

  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. If you use this application with APS, use the Generate Application Schema Metadata Extensions Script form to create a SQL script with table-based attribute extensions metadata.
  4. Load the SQL scripts into other sites (Application Databases), which must also contain any applicable new or modified schema elements.
  5. At these other sites, use the Trigger Management form to generate triggers for specified tables.
Related topics