Amazon RDS for SQL Server Topics

Syniti Replicate supports use of Amazon RDS for SQL Server for:

• Refresh replications, both source and target
• Mirroring replications, both source and target. For source connections, Syniti Replicate offers the Log Server Agent, transaction log support and triggers
• Synchronization

When setting up SQL Server for use with the transaction log:

1. Define two connections to the database: a non-system administrator connection and a system administrator connection (DBMS tools).

2. Set up the distributor (Management Center).

3. Establish primary keys on tables (or use trigger-based replication option) (Management Center or DBMS tools).

This section contains topics that describe:

• SQL Server Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)

• SQL Server Transaction Log Information (in the Create Replication wizard and Create Multiple Replications

Source Log Info screen)

Further Resources

• For a complete up-to-date list of supported sources and targets, and information on where to obtain a .NET provider, check the Supported .NET Providers article in the Help Center.
• The Help Center also provides database-specific setup notes in PDF format.