PowerDesigner is capable of generating sophisticated SQL scripts as files or for execution via a live database connection.
Connecting to a Database
PowerDesigner provides various methods for connecting to your database.
Generating a Database
PowerDesigner can generate a database creation script that you can run in your DBMS environment or generate a database structure directly to a live database connection.
Using Test Data
Test data is sample data that you can define and generate for one or more tables in a PDM. When you generate test data, PowerDesigner automatically generates rows of data in database tables.
Estimating Database Size
You can estimate the size of a database for all the tables in the model or for only selected tables throughout the model.
Modifying a Database
You can modify an existing database schema by synchronizing it with your model. The existing schema can be in the form of:
Accessing a Database
PowerDesigner allows you to display data from the database that corresponds to your model, and to send SQL queries to a connected data source.
Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com