Data Management (DMS) lets you batch-populate database tables with large volumes of test data in a single operation. Supported data types include random values, region names, and virtual IP addresses.
Prerequisites
Before you begin, make sure you have:
A table created in the target database. To create a table, see the "Create a table" section in Manage a database on the SQLConsole tab.
In this example, the database is poc_dev and the table is big_table.
Generate 1,000,000 rows of test data
The following steps show how to submit a test data generation ticket and verify the result.
Log on to the DMS console 5.0.
In the top navigation bar, choose Database Development > Environment Construction > Test Data Generation.
If you use DMS in simple mode, move the pointer over the
icon in the upper-left corner and choose All functions > Database Development > Environment Construction > Test Data Generation.In the upper-right corner of the page, click Test Data Generation.
On the Test Data Generation Tickets page, complete the parameters in the Application step. For the Conflict Handling parameter, select the strategy based on how you want DMS to handle primary key or unique key conflicts:
Strategy Behavior Skip when encountering data conflicts Skips conflicting records and continues writing the remaining data Replace when encountering data conflict Updates the conflicting records and continues writing the remaining data Click Submit.
After the ticket is approved, DMS automatically generates and runs the SQL statements. Track progress on the Ticket Details page.
After data generation completes, run the following query in the SQL Console to confirm the row count:
In the Basic Information section of the page, hover over the database name.
Click Query. DMS opens the SQL Console.
Run the following statement and click Execute:
SELECT COUNT(*) FROM `big_table`;
What's next
For more information about test data generation options, see Generate test data.