RISE to Bloome Software
Log In    
r2bsoftware.se r2bsoftware.se
Click to hide navigation tree

SQL Server code generator

The SQL Server code generator for RISE generates a native Transact SQL script. The script incrementally updates the tables, columns, indexes and constraints in the database to match the RISE model. Once the database model is updated, the views defined in the RISE model are created, or replaced, in the database and possible default data, entered in the model, is inserted. If you are new to RISE, please read more in the RISE Resource Center and if you haven't done so yet, download RISE it's Free!

All database objects handled by the script are named in accordance with the selected RISE model naming convention. The default convention supports having multiple models in the same SQL Server logical database. 

RISE attribute types are mapped to columns according to:
Identifier bigint/int¹ identity(1,1)
Int bigint/int¹
String(n) nvarchar(n)²
Bool bit
DateTime datetime
Float float
Blob image
Text ntext²
¹ It's a model property whether to use 64- or 32-bit integers.
² Supports UNICODE (UTF-8).

Code generator settings

You may change the settings prior to generating code. It's also possible to store the settings as your default settings. The default settings are automatically used when generating code inside the RISE Editor or from a command-line

The SQL Server code generator has the following properties:
ignoreRISE Ignoring RISE means not checking against nor updating the history log prior to running a statement.
logXML Logs the RISE model XML chunk corresponding to the statement.
By default the settings are False, True which generates a Transact SQL script with full RISE logging. To turn off RISE altogether toggle the settings, i.e. change to True, False. Turning off RISE logging will prevent RISE from being able to help you when updating systems deployed using older versions of the model.