About the Data Maintenance Wizard

Use the Data Maintenance Wizard (DMW) to quickly create a table, IDO, and (optionally) form, all from a single procedure. This wizard is especially helpful when you want to create a new form, instead of building on top of an existing database schema. In addition to the basic creation of one or more SQL tables, IDOs, and optional forms, you can use this wizard to accomplish these tasks:

  • Create and link table and property definitions.
  • Create subcollections at the same time you are creating the primary collection, using the Add Subcollection button.
  • Optionally, set up the IDO/table/form for multi-site operations.

You can also use the Data Maintenance Wizard to generate SQL scripts for user-defined data types (UDTs) and optionally, copy them to the system clipboard and/or save them.