Consider primary database issues specific to the Microsoft SQL Server data
server in an SAP replication system.
Note: Replication Agent for Microsoft SQL Server must be installed
on Microsoft Windows.
Replication Agent for Microsoft SQL Server
As a primary data server, Microsoft SQL Server interacts with Replication Agent. The Replication Agent must be installed on Microsoft Windows and must have direct access to the Microsoft SQL database log.
sybfilter Driver
sybfilter driver is use to make the Microsoft SQL Server log files readable before Replication Agent can replicate data.
Microsoft SQL Server System Management
The Replication Agent provides a number of commands that return metadata information about the primary database (such as database names, table names, procedure names, and column names).
Replication Agent Permissions
The user ID that the Replication Agent instance uses to log in to Microsoft SQL Server must have access to the primary database.
Primary Data Server Connectivity
Replication Agent requires a JDBC driver to communicate with the primary database. JDBC drivers for Microsoft SQL Server databases are provided by third-party database vendors.
Replication Server and RSSD Connectivity
Replication Agent uses TCP/IP and the SAP JDBC driver (SAP jConnect), which is included in Replication Agent installation) to communicate with other servers. The Replication Agent does not rely on the interfaces file for connectivity information.
Replication Agent Objects
Replication Agent creates objects in the primary database to assist with replication tasks.
Replicate Microsoft SQL Server Large Value Data Types
Replication Server supports the replication of Microsoft SQL Server large value data types varchar(max), nvarchar(max), and varbinary(max). These datatypes can each store up to 2,147,483,647 bytes of data..
Created April 14, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com