This section describes how to use Data Management Service (DMS) to synchronize table structures.
Issue
Enterprises divide their database environment into production environment and testing environment. Data is verified in the testing environment and then published in the production environment. If some table structures are not synchronized between the testing environment to the production environment, errors occur.
Solution
Enterprises can use the compare table structures feature of DMS to detect table structure inconsistencies between the testing environment and production environment and then obtain Data Definition Language (DDL) statements to fix the inconsistencies.
- Table structure synchronization between the testing and production environments
The following figure shows how to use the table structures comparison feature to synchronize table structures: