Microsoft SQL Server Primary Database Configuration

Learn about the additional issues that are specific to heterogeneous replication.

All the installation issues and configuration parameter details for a Microsoft SQL Server primary data server are in the Replication Agent Installation Guide.

• rs_source_ds and rs_source_db Configuration Parameters
  All configuration parameter values in the Replication Agent configuration file are case-sensitive.
• filter_maint_userid Configuration Parameters
  If you use a Microsoft SQL Server login with sysadmin privilege as a maint_user, map the login to a user in the corresponding database, otherwise, the Replication Agent cannot correctly filter the transaction performed by this maint_user.
• ltl_character_case Configuration Parameter
  The Replication Agent ltl_character_case configuration parameter controls the case in which the Replication Agent sends database object names to the primary Replication Server.