Previous Topic: Customize a Template FileNext Topic: Open a Different Template File to Use with Forward Engineering


Customize a Template File During Schema Generation

You can customize your schema generation options by modifying a default forward engineering template file in the Template Editor. Your customizations can add to or modify the options that are set in the Forward Engineer and Alter Script dialogs. For example, you can add or modify templates to navigate or extract content from your model.

Each database has a corresponding forward engineering template file. The template files are automatically installed to the \Program Files (x86)\erwin\Data Modeler r9\BackupFiles\Templates folder. These template files are quite extensive so they cover all of the SQL required for erwin Data Modeler's processes. Therefore, when you customize a template file, you should begin with the default template file and modify it for your specific needs. Save the template file using either the existing file name or providing a new name, and then associate it with a model for schema generation tasks.

Note: When you save a forward engineering template file using the default file name provided in this product, you are overwriting the template file. If you need to revert to the original, unchanged forward engineering template file, read-only backup copies are located in the \BackupFiles\Templates folder.

Rather than customizing a template file for schema generation outside of the schema generation process, you can customize a template file as you begin the schema generation process. Follow these steps to customize a template file during schema generation:

  1. Open the Template Editor in either of the following ways, depending whether you are performing Forward Engineering or Alter Script/Schema Generation:
  2. Select the template file that you want to customize. By default, the Template Editor opens using the default template file for the target database of your model. If you want to use a different template file, click the Open Template File icon to open the Open dialog and select the template file that you want.
  3. Customize the template using any of the following features in the Template Editor:
  4. Click the Save Template File icon when you are done customizing the template.
  5. Enter a file name to save it as a new (*.fet) template file or use the existing file name and click Save.
  6. Click Close to close the Template Editor.
  7. Click the Browse button to select the template file you just customized. The path for this file should display in the Database Template box. When you select the template it is associated with the model, and you can continue the schema generation process using the customized template file.

More information:

The Template Editor

Using Option Sets