Menu
I see this question here on SO but I am not sure that answers my question. My Central SQL server is 2005 Standard. I am developing an app that requires SQL Express to be installed locally. I am then programmatically creating the Subscriptions and then Syncing them.
Can I use 2008 Express for this on the local machines?
684
We can use either SQL Server 2012, 2014, 2016, 2017 or 2019 as a distributor and SQL Server 2008/R2, 2012, 2014, or 2016 as a subscriber. You can see the complete matrix over the Transactional Replication Matrix.
After a subscription is created, it cannot be changed from one type to another. Azure SQL Managed Instance can be a publisher, distributor, and subscriber for snapshot and transactional replication. Databases in Azure SQL Database can only be push subscribers for snapshot and transactional replication.
Transactional replication is a feature of Azure SQL Managed Instance and SQL Server that enables you to replicate data from a table in Azure SQL Managed Instance or a SQL Server instance to tables placed on remote databases. This feature allows you to synchronize multiple tables in different databases.
In short, yes.
The technology is backwards compatible and so a SQL Server 2008 subscriber can receive a subscription from a SQL Server 2005 Publisher.
For detailed documentation on the backward compatibility of SQL Server Replication please consult the following reference:
http://msdn.microsoft.com/en-us/library/ms143323.aspx
126
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
