--- title: "AWS RDS for SQL Server" slug: "aws-rds-for-sql-server-overview-replicate-cloud" updated: 2026-05-12T17:05:57Z published: 2026-05-13T15:28:51Z canonical: "skthelp.syniti.com/aws-rds-for-sql-server-overview-replicate-cloud" --- > ## 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. # AWS RDS for SQL Server ## Overview Replicate Preview enables efficient data movement between Amazon RDS for SQL Server and other supported systems, allowing it to be configured as both a source and target endpoint. Users can quickly define replication pipelines by selecting source tables and configuring target destinations, enabling data to be replicated with minimal setup and operational overhead. The platform simplifies pipeline creation while ensuring consistent and reliable data delivery across managed SQL Server environments. > [!NOTE] > Note > > Microsoft SQL Server is currently supported as both a **source and target endpoint** in Replicate Preview, limited to **Snapshot (full load) replication mode**, with Change Data Capture (CDC) and streaming replication not yet supported. ### Supported Versions Microsoft SQL Server is supported for the following versions: SQL Server 2017, 2019 and 2022 ### User Permissions When setting up replications that use SQL Server as either a source or target database, you need to ensure that the User ID used for establishing connections to the database has sufficient privileges to complete all the operations required for Replicate Preview to perform a replication. #### Authorize to Connect the Database This permission must be granted already when the user is created. However, if the user is not authorized to establish a connection, you can use the command syntax. ```plaintext grant connect to ; ``` #### Authorize to Select Catalog This permission is required for the Metadata Scanner and allows you to display a list of tables and show fields in the table. ```plaintext use ; exec sp_addrolemember 'db_datareader', '' ``` #### Authorize to Create Tables (Target Only) This permission is required when using SQL Server as a target endpoint and allows you to create target tables. ```plaintext use grant alter on schema:: to ; grant create table to ; ``` #### Authorize to Insert, Update and Delete (Target Only) This permission is required when using SQL Server as a target endpoint and allows you to write records in target tables. ```plaintext use grant select, insert, update, delete on schema:: to ``` ### **Connection Considerations** If you do not have a connection configured, refer to [Connecting to Microsoft SQL Server](/v1/docs/connecting-to-sql-server) for step-by-step instructions. - Ensure the correct **hostname**, **port**, and **database name** are configured - Verify that the source and/or target databases exist prior to replication - Confirm that the configured user has appropriate permissions for the selected role (source vs target) ### **Limitations** - Replication is limited to **Snapshot (full load) mode** in Replicate Preview - Databases, schemas, and tables names containing special characters like slash (/) or backslash (\) are not supported. - SQL_Variant datatype is not supported. ## Related Articles - [Create a Connection](/v1/docs/create-a-connection) - [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) - [Connecting to Microsoft SQL Server](/v1/docs/connecting-to-sql-server)