Troubleshooting guide

CHAPTER 5
Microsoft SQL Server-to-SAP
HANA Database Replication
Setup
Implement a sample replication system for replication from Microsoft SQL Server to SAP
HANA database.
Use the tasks in this document to set up a proof-of-concept or test replication system.
These tasks use the sample Replication Server instance SAMPLE_RS. If you have already
installed Replication Server, skip to the configuration procedures.
For the most current information on Replication Server and its components, see the
Replication Server Release Bulletin .
System Architecture
There are multiple components required to implement an Microsoft SQL Server-to-SAP
HANA Database replication system.
• A primary Microsoft SQL Server data server
• A replicate SAP HANA database
• A Replication Server (with ExpressConnect for HANA DB)
• The Replication Server Options components:
• Replication Agent for Microsoft SQL Server
Figure 3: Sybase Replication System for a Microsoft SQL Server Primary and
SAP HANA Database Replicate
Quick Start Guide for SAP HANA Database 51