Setting up data generator

This topic describes how to set up Data Generator to generate test data.

It is recommended to back up the database that you are going to populate before you generate the data. You can adjust the settings and repeat the data generation if you are not satisfied with the results. To generate data, first select a MySQL server instance and a database you want to populate.

To generate data:

  1. On the Standard toolbar, click New Data Generation.
  2. Specify the connection and select a required database.

connection

  1. Click Next. The Options page will appear.

options

  1. On the Options page, set required options.
  2. Click Execute. The following page displays data generation result.

execute data generation

You can specify the tables that you want to populate by selecting the check box that is located next to the table name. Further, you can define how you want the data to be generated: click the table name in the tree view and specify the details in the settings pane. All the changes are displayed in real-time.

Note:

There may be errors during data generation. For example, a column may be a foreign key of a table, that is not included into generation.

To resolve such issues, navigate to the Related Tables section of the Table generation settings, and include-exclude parent and child tables from data generation.

  1. On the Data Generator toolbar, click Generate Data.

The Output window will open, where you can:

  • select the Open data population script in the internal editor option to add custom data to the database
  • save the SQL script to a file
  • run the script automatically

Select a required option and click Next.

  1. On the Options tab, configure the synchronization options. Click Next.

  2. The Summary tab allows you to see the details of an error or warning.

When you are setting up the tables and columns that you want to populate, SQL Data Generator displays warning and error messages to inform you when there may be a problem with the data generation.

  1. Click Generate to finish the process.