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
When setting up SQL Server for use with the transaction log:
Define two connections to the database: a non-system administrator connection and a system administrator connection (DBMS tools).
Set up the distributor (Management Center).
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)
Limitations
SQL_Variant datatype is not supported. For more information on the SQL Server database’s limitations, refer to the Microsoft documentation.
