Database Contextual Menu

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 "Generating a Database" in the Generating a Database from a PDM chapter of the Data Modeling Guide.

Modify Database

Modifies an existing database schema by synchronizing it with your model. See "Modifying a Database" in the Generating a Database from a PDM chapter of the Data Modeling Guide.

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 the Reverse Engineering a Database into a PDM chapter of the Data Modeling Guide.

Connect

Connects to a data source. See "Connecting to a Data Source" in the Models chapter of the Core Features Guide.

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.