I am trying to create a transactional replication with updatable subscription in SQL Server Management Studio 2017 , meaning changes will be replicated from the publisher to the subscriber and vice versa but the option is missing in the Publication Type wizard. And the settings to enable it from the publication properties are greyed out and cannot be changed. any help ?
Asked
Active
Viewed 155 times
1

jarlh
- 42,561
- 8
- 45
- 63

digital_fiasco
- 11
- 1
-
1What version(s) of SQL Server? Ref: [Updatable Subscriptions - For Transactional Replication](https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/updatable-subscriptions-for-transactional-replication) _This feature remains supported in versions of SQL Server from 2012 through 2016. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature._ – AlwaysLearning Dec 30 '21 at 10:51
-
..for Enterprise or Standard editions – lptr Dec 30 '21 at 10:55
-
1My SQL Server version is 2017, So if this feature is no longer available, is there any alternative solution ? Im kinda new to SQL – digital_fiasco Dec 30 '21 at 11:06
-
1You have to do some research on your own. SQL Server has many version and comes in a few editions (Enterprise - the most expensive, Standard - "cheaper", Development - has everything but for non production purposes only etc.). Each version and edition support their own set of features. – Alex Dec 31 '21 at 00:27