Data Management (DMS) provides the feature to generate a large amount of test data at a time, including random values, region names, and virtual IP addresses. This way, you do not need to manually generate test data.

Procedure

This example shows you how to generate one million records of test data in the big_table table.

  1. Log on to the DMS console 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 SQLConsole tab.
    Go to the SQLConsole tab of the poc_dev database
  3. On the SQLConsole tab, right-click the big_table table and choose Data Plans > Test Data Generation.
    Test Data Generation
  4. In the Test data build-big_table dialog box, set the parameters that are described in the following table.
    Test data build-big_table
    Parameter Description
    Task Name Required. The name of the task. The name must identify the ticket so that approvers can find the ticket and know what to do with the ticket.
    Configure the algorithm Required. The algorithms that you want to use to generate test data. You can select an algorithm for each column. For more information, see Algorithms.
    Number of rows generated Required. The number of rows of test data that you want to generate. In this example, one million rows of test data are generated.
    Conflict Handling Required. The mode of how to handle data conflicts. In this example, select Skip when encountering data conflicts. Valid values:
    • Skip when encountering data conflicts: If a primary key conflict or a unique index conflict occurs, DMS skips the conflict data record and continues to generate other data records.
    • Replace when encountering data conflict: If a primary key conflict or a unique index conflict occurs, DMS updates the conflict data record and continues to generate other data records.
  5. Click Submit and wait until the approval is complete.
  6. After the ticket is approved, DMS automatically generates and executes SQL statements. You can view the execution progress on the Ticket Details page.
    The progress of test data generation
  7. After the test data is generated, go to the SQLConsole tab and query the generated test data in the poc_dev database.
    View the generated test data