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 Microsoft SQL Server instance and a database you want to populate.

To generate data:

  1. In the Tools menu, click New Data Generation. The Data Generator wizard will open.
  2. Specify the connection and select a required database.

    Data Generator Wizard

  3. Click Next. The Options page will appear.

    Data Generator Wizard -Options

  4. On the Options page, set required options.
  5. Click Execute. The following screen shot shows the data generation result.

    Data Generator Wizard -Options

    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.

  6. 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.

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

  8. 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, dbForge Studio displays warning and error messages to inform you when there may be a problem with the data generation.
  9. Click Generate to finish the process.