Apply Model Changes to Database Dialog Options

General tab

The following options are available on this tab:

Option	Description
Directory	[required] Specifies the destination directory for the script file.
File name	[required] Specifies the destination filename for the script file.
One file only	Specifies that the generation script is created as a single file. By default, a separate script file is created for each table.
Generation Type	Specifies the type of generation to perform. You can choose between: Script generation - generate a script to be executed on a DBMS at a later time Direct generation – generate a script and execute it on a live database connection
Edit generation script	[available only when direct generation is selected] Opens the generation script in a text editor for review or editing before execution on a live database connection.
Obtains database schema	Select the kind of schema that the model will modify. You can choose between: Using an archive model - Modified PDM is merged with an archived PDM. Using a data source - Modified PDM is merged with a reverse engineered database schema for a live database connection. Using a script file - Modified PDM script file is merged with an existing database script file. Using a model from repository - Modified PDM is merged with a selected version of a PDM consolidated in the repository.
Backup tables	Specifies that any existing table will be copied to temporary backup tables during the modification, and then restored to the updated tables. If this option is not selected, then all existing data will be erased.
Always use create statements/ Use alter statements when possible	Select a radio button to specify whether create statements should always be used to modify database tables, or whether alter statements should be used where possible
Drop temporary tables	[available only when Backup Tables is selected] Specifies that the temporary backup tables are removed after script execution.
Use physical options for temporary tables	[available only when Backup Tables is selected] Specifies that the temporary backup tables are generated with their physical options.
Check model	Specifies that a model check is performed before script generation.
Automatic archive	Creates an archive version of the PDM after generation.

Options Tab

The availability of these options is dependent on the selected DBMS:

Option	Result of selection
Inside/ Outside	Specifies whether and where various constraints will be generated. Note that if alter statements are used to modify tables, then constraints may be generated outside the table even if the inside radio button is selected here.
Index Filter	Specifies which kinds of indexes to generate.
Comment	Specifies whether comments are generated.

You can load option settings previously used for database generation via the Settings set bar at the bottom of the tab. For more information, see Quick Launch Selection and Settings Sets.

Format Tab

This tab controls the format of your modification script, and has the same functionality as the equivalent tab in Database Generation (see Database Generation dialog Format tab).

Selection Tab

The Selection tab allows you to specify individual objects to generate, and has the same functionality as the equivalent tab in Database Generation (see Database Generation dialog Selection tab).