Replication of Quoted Identifiers at the Table Level

You can configure dsi_quoted_identifier at the table level for an object to instruct Replication Server to replicate quoted objects correctly.

Suppose you perform table replication on a connection, where the connection-level dsi_quoted_identifier is on and subsequently you set up database replication on the same connection to replicate tables with quoted identifiers. This requires the connection-level dsi_quoted_identifier to be set to always. The existing table replication may fail because the table name and column names are all quoted. To make sure that the existing table replication is successful, set table-level dsi_quoted_identifier to on for the table.

In earlier releases, you could only set the dsi_quoted_identifier parameter at the connection-level or at the server-level. With Replication Server 15.7.1 SP200, you can set dsi_quoted_identifier at the table-level. The table-level dsi_quoted_identifier setting takes precedence over any existing connection-level dsi_quoted_identifier setting and the connection-level setting takes precedence over the server-level dsi_quoted_identifier setting.

If there are quoted identifiers in a primary table, to ensure replication proceeds correctly, you must create a table replication definition with the quoted clause and also set the connection-level dsi_quoted_identifier to on.

If there are quoted identifiers in a primary table and if you use create subscription with the init replicate table option for a table replication definition, you must set dsi_quoted_identifer to always and make sure that:

The primary table name that you specify in the table replication definition must be the same as the table name in the primary database.
The Replication Agent parameter ltl_character_case is set to asis. This ensures that the object names are sent in the same character case as they are specified in replication definitions.
The column name that you specify in the table replication definition is the same as the column name in the primary database.
The owner name that you specify in the schema mapping is the same as the owner name in the primary database.
If you plan to drop the table replication definition after you create a database replication, you must quote all the identifiers (including the table name and column names) in the table replication definition.

See Quoted Identifiers in the Administration Guide: Volume 1.