All Products
Search
Document Center

Data Management:Synchronize the data dictionary of a database instance

Last Updated:Feb 29, 2024

After you register a database instance in the Data Management Service (DMS) console, DMS automatically collects the data dictionary of the database instance. If you find that the instance information in DMS is inconsistent with the actual instance information, you can manually synchronize the data dictionary. If you change the schema of a database in DMS, DMS automatically synchronizes the data dictionary. In other cases, you must manually synchronize the data dictionary.

Background information

A data dictionary is used to classify and manage permissions on databases, tables, fields, and programmable objects. The synchronized data dictionary of a database instance includes the following information:

  • The names and character sets of the databases in the instance.

    Note

    By default, if the control mode of an instance is set to Security Collaboration, the system database of the instance is ignored when metadata is collected from the instance. For more information, see System databases blocked by DMS by default.

  • The names, occupied storage space, number of rows, character sets, fields, indexes, and descriptions of the tables in the databases.

  • The types, precision, and descriptions of the fields in the tables.

Take note of the following rules on data dictionary synchronization:

  • If you perform a schema change on a database instance by using DMS, DMS automatically synchronizes the data dictionary of the database.

  • If the scheme change is performed in another way, you need to manually synchronize the data dictionary.

For more information about dictionaries, see Metadata.

Prerequisites

You are a database administrator (DBA) or a DMS administrator. For more information about how to view the role of a user, see View system roles.

Procedure

Method 1

  1. Log on to the DMS console V5.0.
  2. In the top navigation bar, choose Database Assets > Instances.

    Note

    If you use the DMS console in simple mode, move the pointer over the 2022-10-21_15-25-22.png icon in the upper-left corner of the DMS console and choose All functions > Data Assets > Instances.

  3. Click the Instance List tab.

  4. Find the instance that you want to manage, move the pointer over More in the Actions column of the instance, and then select Refresh/Sync Dictionary.

  5. In the Sync Dictionary message, click OK.

Method 2

  1. Log on to the DMS console V5.0.
  2. In the left-side navigation pane on the homepage of the DMS console, right-click the instance that you want to manage and select Refresh / Sync Dictionary.

  3. In the Sync Dictionary message, click OK.