Chapter 4 Building an Information Liquidity Model


Working with the database contextual menu in an ILM

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

Commands in Database contextual menu
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 by ODBC Allows you to directly execute a script on a connected database using an ODBC driver that will allow you 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 PDM

ODBC data source

Generation script file
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 an ODBC 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) 2006. Sybase Inc. All rights reserved.