All the installation issues and configuration parameter details for a Microsoft SQL Server primary data server are provided in the Replication Agent Installation Guide. However, this section describes additional issues specific to heterogeneous replication.
All configuration parameter values in the Replication Agent configuration file are case sensitive. Be careful when specifying the values of the rs_source_ds and rs_source_db parameters, as Replication Server is also case sensitive. If the same case is not used in both Replication Agent and Replication Server parameters, no connection occurs.
If you use a MSSQL login with sysadmin privilege as a maint_user, you should map the login to a user in the corresponding database, otherwise the Replication Agent can not filter the transaction performed by this maint_user correctly.
The Replication Agent ltl_character_case configuration parameter controls the character case in which the Replication Agent sends database object names to the primary Replication Server.
For example, if a replication definition is created for all tables named testtab, the table name sent by the Replication Agent must be testtab, or no match occurs. Because Replication Server is case sensitive, a value of TESTTAB does not match a value of testtab.
If you create replication definitions, choose a default case (for example, create all replication definitions in either all uppercase or all lowercase), and change the value of the Replication Agent ltl_character_case parameter to match.
The following is dependent on the collation you provided when you create the database. In a Microsoft SQL Server database, object names are stored in lowercase by default, if no case was forced when the object was created. That means the Replication Agent sends object names in lowercase to the primary Replication Server, unless configured to do otherwise.
For more information on the ltl_character_case parameter, see the Replication Agent Administration Guide.
