A database model, or Relation Database Model, can be generated from your information model by selecting how to generate it and a code generator to use. A database model can be generated either directly to file, by the RISE Editor itself, or by sending the model to a RISE Server for generation, see Using the RISE Server for more details.

 

To generate database code directly to file select menu item "Generate to File" in the Tools menu of the RISE Editor. This will display the below generator dialog. Select a code generator and, if needed, modify its properties and click the "Generate code" button. The generated code will be displayed in a tab page. Press the "Save selected tab to file" (or "Save all tabs to file") button to save the result to disk.

 

 

The option to generate code to file is always present - provided your RISE Editor is licensed for code generation - and doesn't require any server components to be available.

The database model is created as a script consisting of a sequence of commands leading to the intended final result. A database model is made up of three different parts:

In the following model

 

 

could correspond to the following pseudo code for the model evolution. The exact order of the commands below would depend on in which order they where actually created. Of course, the sequence below could contain commands for modifying already created items as well.