Generating a database

To generate a database you will need to have a project open.

To keep the generated database up-to-date, it may be necessary to repeat this process after changes are made to the project configuration. In particular, it is likely that changes to entities, attributes or relationships will require the process to be repeated, however it ultimately depend on the database template being used.

The following steps describe one way of generating a database for your application:

  1. Open the Generate Database Script dialog from the application menu, Project -> Generate Database.
  2. Add all entities to the Selected list by pressing the Add All button.
  3. Select your database in the Database combo, or select Generic if your database is not there.
  4. Check the Create tables option.
  5. Check the Constraints option if you want constraints to be created.
  6. Check the Test records option if you would like the database to be populated with test records.
  7. Check the Support tables option to create the additional support tables required by the application.
  8. Press the Generate button to generate the database script.
  9. The Execute Sql tab should be open and displaying the generated sql.
  10. Select the connection to your database in the Connection combo. (You may need to setup a database connection if the correct one does not exist).
  11. Press the Execute button to execute the script.

Related concepts

Test records

Related tasks

Opening a project
Setup a database connection

Related reference

Generate Database Script dialog
Generate Database tab