When you configure a Data Transmission Service (DTS) task, you can specify the capitalization of database names, table names, and column names in the destination instance.

Limits

When you specify the capitalization of object names in the destination instance, take note of the following limits:

  • You cannot specify capitalization rules for views, functions, or stored procedures. If a table in the destination database is renamed, the corresponding views, functions, and stored procedures may fail to be created.
  • The objects cannot contain CHECK constraints or computed columns.

Capitalization rules

DTS supports the following capitalization rules for object names:

  • DTS default policy

    DTS configures the capitalization of database names, table names, and column names in the destination instance based on the database type and related parameters, such as lower_case_table_names.

    Destination database type Destination database parameter Capitalization of object names in the destination instance
    • Self-managed MySQL database or ApsaraDB RDS for MySQL instance
    • ApsaraDB RDS for MariaDB TX
    • PolarDB for MySQL
    • PolarDB-X
    • AnalyticDB for MySQL V3.0
    The lower_case_table_names parameter is set to 1 or 2. Database names and table names in the destination instance are in lowercase. The capitalization of column names in the destination instance is the same as that in the source instance.
    The lower_case_table_names parameter is set to 0. The capitalization of database names, table names, and column names in the destination instance is the same as that in the source instance.
    • AnalyticDB for MySQL V2.0
    • DataHub
    • MaxCompute
    • HybridDB for MySQL
    None Database names, table names, and column names in the destination instance are in lowercase.
    Self-managed Oracle database None Database names, table names, and column names in the destination instance are in uppercase.
    • Self-managed SQL Server database or ApsaraDB RDS for SQL Server instance
    • PolarDB O Edition
    • Self-managed PostgreSQL database or ApsaraDB RDS for PostgreSQL instance
    • ApsaraDB RDS for PPAS
    • AnalyticDB for PostgreSQL
    • Self-managed Db2 database
    • Self-managed MongoDB database or ApsaraDB for MongoDB instance
    • Self-managed Redis database or ApsaraDB for Redis instance
    • Tablestore
    • Elasticsearch
    None Database names and table names in the destination instance are in lowercase. The capitalization of column names in the destination instance is the same as that in the source instance.
  • Consistent with the source database

    The capitalization of database names, table names, and column names in the destination instance is the same as that in the source instance.

  • Consistent with the default policy of the destination database (uppercase)

    The names of all the databases, tables, and columns that are migrated or synchronized to the destination instance are in uppercase.

  • Consistent with the default policy of the destination database (lowercase)

    The names of all the databases, tables, and columns that are migrated or synchronized to the destination instance are in lowercase.