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.
   
3. On the SQLConsole tab, right-click the big_table table and choose Data Plans > Test Data Generation.
   
4. In the Test data build-big_table dialog box, set the parameters that are described in the following 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.
   
7. After the test data is generated, go to the SQLConsole tab and query the generated test data in the poc_dev database.