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.
- Log on to the DMS console V5.0 as a regular user.
- In the instance list, click the
poc_dev
instance and double-click the poc_dev
database to go to the SQL Console tab.
- On the SQL Console tab, right-click the
big_table
table and choose .
- In the Test data build dialog box, set the parameters as described in the following table.

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.
|
- Click Submit and wait for the approval result.
- After the ticket is approved, DMS automatically generates and executes SQL statements.
You can view the execution progress on the Ticket Details page.
- After the test data is generated, go to the SQL Console tab and query the generated
test data in the
poc_dev
database.