Live Database Generation

PowerDesigner can generate or modify a database from a PDM to a live connection. The statements that control live generation are available in the Script/Objects category, except when the DBMS does not support standard SQL syntax. For example, MS Access, which needs VB scripts to create database objects, has special generation statements defined in the ODBC category.

When generating to a live connection, PowerDesigner takes each object to be created in turn, and applies the appropriate Create or other statement to create or modify the object.

The statements used in live generation are the same as those for script generation (see Script Generation).