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.