Help Center > > User Guide> MySQL DB Instance Management (Development Tool)> Data Scheme> Data Generator

Data Generator

Updated at: Jun 09, 2021 GMT+08:00


During the functional testing of a program, a large amount of test data complying with specific rules needs to be inserted into the database. DAS allows you to automatically, efficiently generate test data based on specific rules.


  1. On the top menu bar, choose Data Scheme > Data Generator.

    Figure 1 Data Generator

  2. On the displayed page, click Create Task. In the displayed dialog box, configure the required parameters.

    Figure 2 Creating a data generation task
    Figure 3 Configuring task parameters
    • Rows to Generate

      A maximum of 1,000,000 rows of data can be generated.

    • Conflict Policy

      If you select Skip, the system skips data rows in conflict and continues generating data. If you select Replace, the system replaces existing rows with new ones that have the same primary key.

    • Generation type

      You can set the rules for randomly generated data based on the column settings. For example, if the column type is time, you can set the start time, end time, and format, or set the value to the current time.

  3. Click Preview to check whether the generated data is as expected. If not, modify the settings. Then, click Generate. Alternatively, directly click Generate.

    Figure 4 Data preview
    Figure 5 Test data generation progress

  4. In the task list, locate the created task and click Details. You can also delete the task as required.

    Figure 6 Task list

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel