Chapter 3 Building Information Liquidity Diagrams


Working with the database contextual menu

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.

For more information about the PDM commands, see the Data Modeling guide.

 


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