Microsoft SQL Server as Replicate Data Server

Learn about the replicate database issues and considerations specific to the Microsoft SQL Server data server in a Sybase replication system.

• Microsoft SQL Server Replicate Data Servers
  As a replicate data server, Microsoft SQL Server interacts with the ECDA Option for ODBC database gateway.
• Replication Intrusions and Impacts on Microsoft SQL Server
  The only significant intrusions or impacts to the Microsoft SQL Server replicate database are the database objects that are created by the connection profile to support Replication Server replicate database operations.
• Replicate Database Limitations on Microsoft SQL Server
  Microsoft SQL Server supports either 28 digits or 38 digits of precision, depending on the server’s start-up options. The default precision is 28 digits.
• Microsoft SQL Server Replicate Database Permissions
  Replication Server requires a maintenance user ID that you specify using the Replication Server create connection command to apply transactions in a replicate database.
• Replicate Database Connectivity for Microsoft SQL Server
  A Replication Server database connection name is made up of two parts: a data server name (server_name) and a database name (db_name).
• Microsoft SQL Server Replicate Database Configuration
  The heterogeneous datatype support (HDS) feature of Replication Server provides configuration information that allows you to set up the HDS feature in the replicate Replication Server and the Microsoft SQL Server replicate database.
• Parallel DSI Threads for Microsoft SQL Server Replicate Database
  In a heterogeneous replication environment, parallel DSI must ensure that the commit order in the replicate database is same as in the primary database.