The contextual menu of a database symbol contains the following commands:
Command |
Description |
---|---|
Generate Scripts |
Lets you generate a script to prepare the replication of tables. This script is to be executed on a connected database at a later time |
Generate and Execute Scripts |
Lets you directly execute a script on a connected database to replicate tables. |
Generate Database |
[PDM command] Lets you generate the database corresponding to the PDM attached to the current model. |
Modify Database |
[PDM command] Lets you generate a database by synchronizing a modified PDM with one of the following existing database schema: Archived model Live database connection Generation script file Model from the repository |
Reverse Engineer Database |
[PDM command] Lets you reverse engineer an existing database into a new PDM. The data source can either be from script files or from a data source. |
Connect |
Lets you connect to a data source before executing an.SQL file. |
Execute SQL |
Lets you execute the .SQL file you have generated using the Generate Scripts command. |