Feature confirmation about MS SQL 2019 Replication

Question

I want to know that I can use Transactional replication updateable subscription on MS SQL 2019.
I can read opposite explanation about MS SQL 2019 on learn.microsoft.com.

1. MS SQL 2019 support it.
   Link: https://learn.microsoft.com/ko-kr/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15
   
   2. MS SQL 2019 don't support it.
      Link: https://learn.microsoft.com/ko-kr/sql/relational-databases/replication/transactional/updatable-subscriptions-for-transactional-replication?view=sql-server-ver15
      

What information is correct?

Answer 1

The second articles says only, that it is a deprecated features and will be removed in future release; by Microsoft that means in 10-20 years.
But that feature is still supported.

Answer 2

Hi @Joo ,

>I want to know that I can use Transactional replication updateable subscription on MS SQL 2019.

Yes, you can.

This feature is still available in SQL Server 2019 Enterprise and Standard edition, but may be removed in a future version. Note that the second document you mentioned was published in 2016, when the latest version of SQL Server was 2016.

Answer 3

I highly suggest you do not try to use a feature which is already deprecated. Although MS generally takes a long time to actually remove depreciated functionality, you should be migrating off that feature.

Please describe your environment and requirements so someone can give a recommendation of using a current feature instead.