Quoted Identifiers Without Replication Definition Support

Replication Server can add quotes to all identifiers without checking whether the identifier is quoted in a replication definition or in the primary Adaptive Server database.

Setting dsi_quoted_identifier to on enables quoted identifier support for primary tables only created in Adaptive Server 15.7.1 and later.

Setting dsi_quoted_identifier to always automatically adds quotes to object names and ensures that replication continues for all primary data servers supported by Replication Server. Otherwise, the DSI connection to the replicate database can shut down and stop replication if Replication Server processes table names that are not quoted and not specified in a table replication definition with the quoted clause. See the Replication Server Release Bulletin for supported Adaptive Server versions and the Replication Server Options Release Bulletin for supported non-Adaptive Server data servers and versions.

You can use the always option for a specific table or for all tables when you configure dsi_quoted_identifier for a connection with create connection or alter connection.

Example

To ensure that replication proceeds even if some table names are not quoted in the corresponding table replication definitions, set the always option for all tables for a new connection to the rdb replicate database in the NY_DS data server. At the replicate Replication Server, enter:

create connection to NY_DS.rdb
...
set dsi_quoted_identifier to always
...
go