All Products
Search
Document Center

Synchronize table structures

Last Updated: Jun 06, 2019

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:

DMS-Compare Table Structures-Table Structure Synchronization