Modify Database dialog General tab

Chapter 13 Generating a Database from a PDM

Modify Database dialog General tab

This tab controls the main options for database modification.

You can set the following options:

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 ODBC generation – generate a script and execute it on a connected data source using an ODBC driver
Edit generation script	[available only when ODBC generation is selected] Opens the generation script in a text editor for review or editing before execution via the ODBC driver.
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 an ODBC data source - Modified PDM is merged with a reverse engineered database schema for an ODBC data source. 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.

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".