Data Management (DMS) provides the test data generation feature that allows you to batch generate various test data at a time, including random values, region names, and virtual IP addresses. This feature helps simplify test data generation.

Procedure

This example shows how to generate 1 million rows of test data for the big_table table.
Note The poc_dev instance and the big_table table in the following steps are for test purposes.
  1. Log on to the DMS console V5.0 as a regular user.
  2. In the instance list, click the poc_dev instance and double-click the poc_dev database to go to the SQL Console tab.
  3. On the SQL Console tab, right-click the big_table table and choose Data Plans > Test Data Generation.
    Test Data Generation button
  4. In the Test data build dialog box, set the parameters as described in the following table.
    Test data build dialog box
    Parameter Required Description
    Task Name Yes The name of the task. To facilitate future searches and help approvers understand the purpose of the operation, specify a detailed task name.
    Configure the algorithm Yes The algorithm that you want to use to generate test data. For more information, see Algorithms.
    Numbers of rows generated Yes The number of rows of test data that you want to generate. In this example, set the value to 1 million.
    Conflict Handling Yes Specifies what the system does when data conflicts occur. In this example, select Skip when encountering data conflicts. Valid values:
    • Skip when encountering data conflict: If a data conflict occurs while writing data of the primary key or a unique key, DMS skips the conflicting data records and continues to write other data records.
    • Replace when encountering data conflict: If a data conflict occurs while writing data of the primary key or a unique key, DMS updates the original data records and continues to write other data records.
  5. Click Submit and wait for the approval result.
  6. After the ticket is approved, DMS automatically generates and executes SQL statements. You can view the execution progress on the Ticket Details page.
  7. After the test data is generated, go to the SQL Console tab and query the generated test data in the poc_dev database.