--- title: "Amazon RDS for SQL Server Topics" slug: "amazon-rds-for-sql-server" updated: 2024-07-25T08:14:54Z published: 2024-07-25T08:14:54Z canonical: "skthelp.syniti.com/amazon-rds-for-sql-server" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Amazon RDS for SQL Server Syniti Replicate supports use of Amazon RDS for SQL Server for: - [Refresh](/v1/docs/setting-up-a-replication) replications, both source and target - [Mirroring](/v1/docs/setting-up-a-replication) replications, both source and target. For source connections, Syniti Replicate offers the [Log Server Agent](/v1/docs/setting-up-a-replication), [transaction log support](/v1/docs/choosing-a-log-type-for-transactional-replications) and [triggers](/v1/docs/trigger-based-transactional-replications) - [Synchronization](/v1/docs/setting-up-a-replication) 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](/v1/docs/sql-server-transaction-log-information) (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog) - [SQL Server Transaction Log Information](/v1/docs/sql-server-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](https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16).