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 use test data to:


You can generate test data for some or all of the tables in a PDM and add it to an empty database or to one that already contains data.

In order to generate test data for some or all of your columns, you must:


  1. Create as many types of test data profile as you need, specifying for each whether PowerDesigner should generate data to populate them or if you will supply the test data in the form of a list, data source connection or csv file.
  2. Assign the profiles to all the columns for which you want to generate test data refining, where necessary, the population of individual columns by specifying column fill parameters.
  3. Generate the test data to your database.