This article provide essential information for Microsoft SQL Server as source or target in Refresh, one-way Mirroring or Synchronization.
SQL Server Versions Supported
| Source | Target | ||||
| Database Version | Refresh | Mirroring | Synchronization | Refresh | Mirroring |
|
SQL Server 2022* |
X | L - T | X | X | X |
| SQL Server 2019 | X | L - T | X | X | X |
| SQL Server 2017 | X | L - T | X | X | X |
| SQL Server 2016 | X | L - T | X | X | X |
| SQL Server 2014 | X | L - T | X | X | X |
| SQL Server 2012 | X | L - T | X | X | X |
L= Log-based X= Supported
T= Triggers N/S= No Supported
All SQL Server versions supported in current releases: Syniti Data Replication 9.8.2.15 and Syniti Replicate 10.2
* SQL Server 2022 is supported in Syniti Replicate 10.3. Contact Sales in your region to get access to this version.
SQL Server Editions Supported
| Source | Target | ||||
| Database Edition | Refresh | Mirroring | Synchronization | Refresh | Mirroring |
| Express Edition | X | T | N/S | X | X |
| Compact Edition | X | T | N/S | X | X |
| Developer Edition | X |
L - T |
X | X | X |
| Standard Edition | X | L - T | X | X | X |
| Enterprise Edition | X | L - T | X | X | X |
| SQL Contained | X | T | N/S | X | X |
Always-On Environment
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduced support for replication distribution database in an Availability Group. Here you can download the setup notes.
Limitations
SQL Server 2000
- Data Types text, ntext and image are not supported by the Triggers transactional replications.
All SQL Server versions
Primary Keys: When using SQL Server as a source in mirroring (or as a source or target in synchronization replications), SQL Server requires that tables have a primary key defined. If tables do not have a primary key, you can set up a trigger-based replication.