Microsoft SQL Server Topics

Syniti Data Replication supports use of Microsoft SQL Server for:

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

When setting up SQL Server for use with the Log Server Agent or 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)

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.