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.


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com