Tool Mentor: Forward Engineering Databases Using Rational XDE Developer - .NET Edition
Purpose
This tool mentor describes the use of forward engineering in the Rational XDE™ software tool to generate a database schema or DDL script file from an existing Rational XDE Data Model.
This section provides links to additional information related to this tool mentor.
Overview
The following steps are performed in this tool mentor:
- Set Model Properties
- Forward Engineer Data Model to a Database
- Manage Changes to the Model and Database
Set Model Properties
Two types of model properties must be set to enable forward engineering of the Data Model to create a database or Data Definition Language (DDL) file. These properties are:
- Default Database Target Database Management System (DBMS) (see )
- Default Database Assignment (see )
Rational XDE supports forward engineering to the ANSI SQL 92 standard and to the database management systems (DBMS) listed in the Rational XDE online Help topic .
For more information, refer to .
Forward Engineer Data Model to a Database
Rational XDE can be used to forward engineer a Data Model to a new database schema or a new DDL file. You can forward engineer individual tables or an entire Data Model. See the online Help topic for an overview of the Rational XDE forward-engineering capabilities. You initiate the forward-engineering process using the data modeling Forward Engineering Wizard provided by Rational XDE. (See .)
Whether you decide to only generate a DDL or to execute the DDL to create a database, Rational XDE creates a DDL file for you in the directory that you specify in the wizard. The elements that Rational XDE includes in the forward-engineering process depend upon the options that you selected in the Forward Engineering Wizard. All elements or DDL scripts are generated according to the specified DBMS. Refer to the following Rational XDE online Help topics for specifics on the different types of supported DBMS:
If you forward engineer an ANSI SQL 92 Data Model, Rational XDE generates a DBMS-independent DDL. You can use the database tool of your choice to execute this DDL.
In order to perform the forward engineering of the database, Rational XDE must establish a connection to the appropriate DBMS. See for more information on establishing database connections. Refer to the following Rational XDE online Help topics for information on establishing connections for a specific DBMS type:
Manage Changes to the Model and Database
After the database or DDL has been created, the changes to the Data Model and generated database must be controlled and managed. Rational XDE provides a Compare and Synchronize feature to assist the database designer in managing change. See and Tool Mentor: Managing Databases in Rational XDE.
|
This content developed or partially developed by  Applied Information Sciences.
|
