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:
- Open the
Generate Database Script dialog from the application menu,
Project -> Generate Database.
- Add all entities to the Selected list by pressing the
Add All button.
- Select your database in the Database combo, or select
Generic if your database is not there.
- Check the Create tables option.
- Check the Constraints option if you want constraints to be created.
- Check the Test records option if you would like the
database to be populated with
test records.
- Check the Support tables option to create the additional support
tables required by the application.
- Press the Generate button to generate the database script.
- The Execute Sql tab should be open and displaying
the generated sql.
- 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).
- 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