View Image

RISE SQL Server code generator The RISE SQL Server code generator 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 is updated, the views defined in the RISE model are created in the database and possible default data, entered in the model, is inserted. RISE Code generators The RISE suit provides a range of free code generators for you to use when transforming your RISE model into software. There are two main categories of code generators: database script generators and application source code generators. Database script code generators The database code generators write an incremental script for creating, and updating, relational databases based on your model. A RISE model contains the entire life-cycle of your data model. The code generator translates this life-cycle into an incremental database specific script. Currently, RISE provides code generators for SQL Server, MySQL and PostgreSQL. Application source code generators The application source code generators generate code for working with databases based on the RISE model. The generated code includes classes for managing database access and for publishing the access layer as web services. Both SOAP and JSON style web services are supported. Currently, two languages are supported C# (.NET) and PHP. The C# code generator outputs code handling all three databases (SQL Server, MySQL and PostgreSQL). For PHP there are two different code generators, PHP for MySQL and PHP for PostgreSQL, creating source code using the respective database native driver. How to run a RISE code generator In order to be both flexible and easy to use, RISE code generators can be launched in several different ways. You may run a code generator: * as an integrated part of the RISE Editor. * as a standalone application from the start menu. * using a script or from command line.