The database contextual menu contains commands that let you perform a wide range of actions.
This menu contains the following commands:
|
Command |
Description |
|---|---|
|
Generate Scripts |
Generates a script to prepare the replication of tables. |
|
Generate and Execute Scripts |
Generates and executes a script on the connected database to replicate tables. |
|
Generate Database |
Generates a database creation script from the associated PDM (see Data Modeling > Building Data Models > Generating and Reverse-Engineering Databases > Generating a Database from a PDM). |
|
Modify Database |
Modifies an existing database schema by synchronizing it with your model (see Data Modeling > Building Data Models > Generating and Reverse-Engineering Databases > Modifying a Database). |
|
Reverse Engineer Database |
Reverse engineers an existing database schema into an existing PDM. The database schema can either be from script files or from a data source (see Data Modeling > Building Data Models > Generating and Reverse-Engineering Databases > Reverse Engineering a Database into a PDM). |
|
Connect |
Connects to a data source (see Core Features Guide > Modeling with PowerDesigner > Getting Started with PowerDesigner > Connecting to a Database). |
|
Execute SQL |
Opens the Execute SQL Query window to let you send SQL queries to a connected data source and display the result. If you are not already connected to the data source, the Connect to Data Source window opens. Choose your connection profile, and click Connect to open the Execute SQL Query window. Enter one or more SQL statements in the dialog to query your database, and click the Run button to apply them to the data source, and display the query results in the Results window. |
The following commands are available for replication server environments:
|
Command |
Description |
|---|---|
Reverse Engineering |
[v15.7 and higher] Reverses table and procedure bindings to data connections and logical paths. |
Bind Tables/Procedures |
[v15.7 and higher] Opens a dialog to allow you to bind tables or procedures to data connections or a logical path (see Binding Database Objects to Connections or Logical Paths). |
Show Table/Procedure Binding Matrix |
[v15.7 and higher] Opens a matrix to allow you to bind tables or procedures to data connections (see Binding Database Objects to Connections or Logical Paths). |
Create Standby Database |
Creates a standby database for a warm standby application (see Modeling a Warm Standby Application |