All Products
Search
Document Center

Generate test data automatically

Last Updated: Jun 08, 2019

Generate test data automatically

  • This topic describes how to automatically generate test data in DMS.

Prerequisites

  • You have access permissions to DMS and you have logged on to the DMS console.

Procedure

  1. Log on to the DMS console.

  2. Select the target MySQL database, and click Log on to Database.

  3. In the top navigation bar, choose Data Operations > Generate Test Data. The Generate Test Data window appears as below.Generate test data

  4. Click Create Task. The Target Database and Target Table dialog box appears. Select the target database and the target table based on your needs.

  5. Configure the generation method for each column. Supported generation methods include random generation, custom generation, logical dependency, and enumeration.

  6. Click Data Preview to view the data generated by the current method.

  7. After you confirm the data, specify the number of data rows and the action for conflicts, click Generate Data.

  8. After the data generation task is completed, click View in the Target Table column or open the target table to view the generated testing data.