This allows you to specify various options for generating a database for your application.
It can be accessed via the application menu Project -> Generate Database or from the toolbar in the Generate Database tab.
Here is an example of what it looks like:
This list displays those entities that will not be included when generating the database script. Double clicking an entity in the list will move it to the Selected list.
This moves the selected entity in the Available list to the Selected list.
This moves the all entities in the Available list to the Selected list.
This list displays those entities that will be included when generating the database script. Double clicking an entity in the list will move it to the Available list.
This moves the selected entity in the Selected list to the Available list.
This moves the all entities in the Selected list to the Available list.
This allows you to specify the type of Relational Database Management System (RDBMS) that you will be creating the database in. If your RDBMS is not listed then you try using the Generic option, or you can create your own database template.
Whether to generate sql that creates tables for the selected entities.
Whether to generate sql that creates the necessary table constraints for the selected entities.
Whether to generate sql that creates test records for the selected entities.
Whether to generate sql that creates any necessary supporting tables for the application.
Whether to generate drop and/or delete sql statements for the previous options. For example, if you have previously created the database tables you should select this option in addition to the Create tables option. This will ensure that the tables are dropped before they are created again.
This generates the database script for the selected options. The generated script is sent to the Execute Sql tab.