About SQL Server and the framework

Microsoft SQL Server is responsible for:

  • Maintaining the relationships between data in the database
  • Ensuring that data is stored correctly and that the rules defining data relationships are not violated
  • Managing data and user security
  • Optimizing server function performance
  • Recovering all data to a point of known consistency in case of system failures

SQL Server is primarily responsible for managing databases that interact with enterprise business systems. Some of the components that make up these databases are:

  • Tables
  • Views
  • Stored procedures
  • Triggers
  • Constraints
  • Indexes
  • Keys
  • User defined data types

These databases are available in the SQL Server: The application database, the forms database, the objects database, and the templates database. In current usage these databases are usually combined into a single "All-in-One" database.

Application database

The application database holds all of the user and administrative data for your Mongoose-based application. This database is made up of tables, stored procedures, triggers, user defined data types, and indexes.

Forms database

The forms database holds all of the metadata used to construct about each form.

For example, components such as text boxes, labels, tabs, radio groups, buttons, and all of the associated properties, such as size, color, validation, and events, are kept in the forms database in a multitude of tables.

Objects database

The objects database stores the IDO (Intelligent Data Objects) metadata.

Templates database

The templates database stores information about form structures from the Form Wizard, This includes such information as the form type, the associated IDO name, IDO properties, and so on. If you decide to recreate a form, all the structural information previously entered is preserved so that you can use it as a base and make incremental changes. This is typically only used in the initial stages of form development. Once you start adjusting layout and adding components, we do not recommend that you recreate the form unless you understand that any changes you have made are lost.