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 typeDestination database parameterCapitalization of object names in the destination instance
    • Self-managed MySQL database or ApsaraDB RDS for MySQL instance
    • ApsaraDB RDS for MariaDB
    • 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
    		NoneDatabase names, table names, and column names in the destination instance are in lowercase.
    Self-managed Oracle databaseNoneDatabase 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
    		NoneDatabase 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.