Database Schema

This generator helps you build a DDL script that creates a SQL Server database from your Xomega object model. It generates all the necessary tables, columns, primary keys and foreign key relationships. The generated script will be rerunnable and would not create the tables if they have already been created.

While maintaining a master DDL script for the database during the development process is a common practice, this generator is most valuable when you start building your object model from scratch and then need to generate a database for the first time.

Once you already have a database populated with data for your development environment, you will want to update the database schema through a database change script, which can also be generated from your Xomega model.

When generating a database for the first time, you need to specify the Database Case property for the generated database names, e.g. UPPER_CASE for case-insensitive databases. The only database that is currently supported is SQL Server.