DDL Installation

CA Gen does not directly support creating databases using ADO.NET. That leaves the user with the following options for installing the DDL into the target DBMS:

Manual installation.
With CA Gen, using the platform and DBMS specific generation options; for instance, generate for UNIX, Oracle and install with the CA Gen installation program.
With CA Gen, using the ODBC/ADO.NET platform. When installing this way, the installation is performed by the Build Tool using an ODBC DDL installation program.

Note:

There is an ODBC/ADO.NET DBMS in the Technical Design for naming objects that will be used in a DBMS that is not supported.
If a DBMS will be used to support traditional CA Gen applications along with ASP.NET Web Clients or Java applications, matching the DBMS to get the table and column names is very important.
When installing DDL using the ODBC approach, the actual database must already exist within the DBMS. ODBC drivers are incapable of performing any type of CREATE DATABASE command themselves.