Forward Engineering
A database design developed in this application can be loaded or forward engineered to a database server to create a functional database on the server.
Forward Engineer a Database Design:
Note: A database (design) must be open before a forward engineer operation can be performed.
On the Tools menu, click Forward Engineer.
In the Forward Engineer window that appears, select the appropriate server connection from the Connection combo box.
In the Script Hierarchy node tree, select the appropriate node to indicate how much of the forward engineering script should be executed.
The SQL commands of the selected script can be previewed or exported from the Script Text panel.
Select the Db Conversions tab to specify any non null data values to be loaded into new columns as tables are repopulated on the database server. Character strings and date values may need to be enclosed in single quotes.
Click Start to begin forward engineering.
Results of the forward engineering operation are documented in the Update Log panel.
Note: Dropping tables and columns requires manual intervention.
Forward Engineer scripts will not drop tables or columns that are no longer needed. This is to prevent the accidental dropping of a table or column and resultant loss of data. To prevent this unwanted data loss, the user is asked to drop old tables and old columns manually.
Note: Column default values maybe enclosed in quotes
Column Default values that contain characters will automatically be enclosed in quotes, but numeric values will not be quoted. To use function values that you do not wish to be enclosed in quotes, preceed the function string with a backtick (`) escape character. Functions containing '()' will be recognized as functions and do not need to be escaped with a backtick.
See also: