Working with Data Models › Forward Engineer/Alter Script › Forward Engineering/Schema Generation › Generate the Schema from the Schema Generation Preview Dialog (Forward Engineering)

Generate the Schema from the Schema Generation Preview Dialog (Forward Engineering)

When you generate the schema, you can generate an ASCII DDL script that you run as a separate step on the server to generate the schema. When you generate a DDL script, you can save it as a text file that you can open in a word-processing package or load it into a utility that interprets SQL scripts.

To generate the schema from the schema generation preview dialog

1. Click Create Subject Area in the physical model and select the subject area for which you want to generate the schema.
2. Click Forward Engineer, Schema... on the Actions menu.
3. Select an option set from the Option Set list.
4. Select the schema generation options.
5. Click Preview to open the Schema Generation Preview dialog.
6. Click Generate to open the <Database> Connection dialog and log on to the target server.
7. Choose any of the following options in the Generate Database Schema dialog:

   Save Model

   Saves the message log to a file.

   Print

   Prints the message log.

   Find

   Searches the message log.

   Close

   Closes the message log.

8. Click Close.

Note: To regenerate the same model schema to the same database, use this procedure. However, you must select the Drop Table check box so that all the existing tables referenced in the schema are deleted before new tables are generated. The information stored in dropped tables is not saved, so if you want to preserve the data in the tables, use the Complete Compare feature.

More information:

Preview the Schema DDL Script