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.
Generating Test Data to a Database
Test data is sample data that PowerDesigner generates as rows in your database tables to verify database performance or to help in estimating the amount of memory that the database will require. You can generate test data for some or all of the tables in your PDM to an empty or existing database.
Estimating Database Size
You can estimate the size of a database for all or some of the tables and other objects in your model. You can estimate the initial size of the database or project its growth over a number of years.
Modifying a Database
You can modify an existing database schema by synchronizing it with your model.
Displaying Data from a Database
You can connect to a database and display the data that corresponds to a PDM table, view, or reference.
Executing SQL Queries
You can send SQL queries to a database and display the results.