Creating a Database Using the Schema

RDM provides a several options for creating a database instance from a schema:

Use rdm-create to create the database using a specified docroot or on a remote TFS;
Use rdm-compile to create data structure in your C/C++ application that will automatically create the database on "open" if it does not exist; or,
Execute the DDL commands directly from your application through SQL.

For these examples, we will be using the rdm-compile utility to create a data structure to embed in the example application program. There is not a recommended way to create a database. The developer should pick the method that make their system design easy to deploy and maintain.

For example:

If the deployed application is a standalone application executable using the RDM native APIs, embedding the schema into the application using the compiled schema components may be easiest.
If the deployed application has multiple application executables and the database is subject to periodic dynamic schema updates, separate utility (application update utility) to apply those changes may be an easier to maintain approach.
If the application is JDBC, ADO .NET, or ODBC based. Using a separate utility to update the schema OR embedding the schema directly in the application may be the approach needed.