Capitalization policy for object names in the destination database (migration task management) - Data Transmission Service

When you configure a Data Transmission Service (DTS) task, you can set a capitalization policy for object names. This policy controls the capitalization of database, table, and column names in the destination instance.

Precautions

If you specify a capitalization policy for object names, the following limits apply to the task objects:

Configuring views, functions, and stored procedures in the task is not supported. Otherwise, if the table name in the destination database changes, the corresponding views, functions, and stored procedures may fail to be created.
Task objects cannot contain check constraints or computed columns.

Policy description

DTS supports the following four capitalization policies:

DTS default policy

DTS sets the capitalization of database, table, 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 parameters	Capitalization rule for object names in the destination instance
Self-managed MySQL, ApsaraDB RDS for MySQL RDS MariaDB PolarDB MySQL PolarDB-X AnalyticDB for MySQL 3.0	`lower_case_table_names` is set to 1 or 2.	Database and table names are mapped to lowercase. The case of column names is consistent with the source database.
	`lower_case_table_names` is set to 0.	The case of database names, table names, and column names is consistent with the source database.
AnalyticDB for MySQL 2.0 DataHub MaxCompute HybridDB MySQL	None	Database names, table names, and column names are mapped to lowercase.
Self-managed Oracle	None	Database names, table names, and column names are mapped to uppercase.
Self-managed SQL Server, ApsaraDB RDS for SQL Server PolarDB O engine Self-managed PostgreSQL, ApsaraDB RDS for PostgreSQL RDS PPAS AnalyticDB for PostgreSQL Self-managed Db2 Self-managed MongoDB, ApsaraDB for MongoDB Self-managed Redis, ApsaraDB for Redis TableStore Elasticsearch	None	Database and table names are mapped to lowercase. The case of column names is consistent with the source database.

Consistent with the source database
The database, table, and column names in the destination database retain the same capitalization as in the source database.
Consistent with the destination default policy (uppercase)
All database, table, and column names that are migrated or synchronized to the destination database are converted to uppercase.
Consistent with the destination default policy (lowercase)
All database, table, and column names that are migrated or synchronized to the destination database are converted to lowercase.