Overview
Replicate Preview enables efficient data movement between Microsoft SQL Server environments, supporting both source and target configurations. Users can quickly define replication pipelines by selecting source tables and configuring target destinations, allowing data to be replicated with minimal setup and operational overhead. The platform simplifies pipeline creation while ensuring consistent and reliable data delivery across SQL Server instances.
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 versions 2016 and later are supported.
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.
grant connect to <user_id>;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.
use <database_name>;
exec sp_addrolemember 'db_datareader', '<user_id>'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.
use <database_name>
grant alter on schema::<schema_name> to <user_id>;
grant create table to <user_id>;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.
use <database_name>
grant select, insert, update, delete
on schema::<schema_name>
to <user_id>Connection Considerations
If you do not have a connection configured, refer to Connecting to Microsoft 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.