This topic describes the features provided by the Data Plans module of Data Management Service (DMS), such as data change, data import, data export, data tracking, and database clone.

Category Feature Description
Data Changes Change regular data You can update data in databases.
Perform lock-free DML operations The SQL statements for changing data are executed for a batch of data at a time based on the primary key or unique key. This allows you to update a large amount of data without affecting business.
Clear historical data You can create a scheduled task to delete historical data. Historical data will be deleted based on configured rules on a regular basis.
Change programmable objects by using stored routines You can submit tickets to change programmable objects, such as stored procedures, triggers, functions, and views.
Import data You can quickly import a large amount of data to a database at a time.
Data Export Export SQL result sets You can export SQL result sets.
Export databases You can quickly export data of databases and tables.
Data tracking / You can parse the binlogs of the target database, query data change records, and quickly generate SQL statements for restoring data.
Environment Construction Database cloning You can replicate the schema and data of a source database or table to a destination database or table.
Generate test data The system can automatically generate test data based on specified field types and rules.