Database object names must be delivered to the primary Replication Server in the same format as they are specified in replication definitions; otherwise, replication fails. For example, if a replication definition specifies a table name in all uppercase, then that table name must appear in all uppercase when it is sent to the primary Replication Server by the Replication Agent.
To specify the character case option you want, set the value of the ltl_character_case configuration parameter to one of the following three options:
asis – (the default) database object names are passed to Replication Server in the same format in which they are actually stored in the primary data server.
lower – database object names are passed to Replication Server in all lowercase, regardless of the way in which they are actually stored in the primary data server.
upper – database object names are passed to Replication Server in all uppercase, regardless of the way in which they are actually stored in the primary data server.
In Microsoft SQL Server, database object names are stored in the same case as entered (uppercase or lowercase). Therefore, you must use the asis option to send database object names to the primary Replication Server in the same case as they are stored in Microsoft SQL Server.
