Chapter 3 Building Information Liquidity Diagrams


Working with the database contextual menu in an ILM

The contextual menu of a database symbol contains the following commands:

Menu Command Description
Generate Scripts Allows you to 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 Allows you to directly execute a script on a connected database to replicate tables
Generate Database (PDM command) Allows you to generate the database corresponding to the PDM attached to the current model
Modify Database (PDM command) Allows you to 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) Allows you to reverse engineer an existing database into a new PDM. The data source can be either from script files or a data source
Connect Allows you to connect to a data source before executing an.SQL file
Execute SQL Allows you to execute the.SQL file you have generated using the Generate Scripts command

For more information about the PDM commands, see the Physical Data Model User's Guide .

 


Copyright (C) 2007. Sybase Inc. All rights reserved.