Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.. GeoPITS brings you the comprehensive details of Snapshot replication's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Version v2017 | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Version v2016 | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Version v2014 | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | |
| Version v2012 | Subscriber only | Subscriber only | Subscriber only |
Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.
You can find more details about this version here
Back to all features