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.
Estimating Database Size
You can estimate the size of a database for all or a selection of tables in the model.
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.