Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1063414%22%20slang%3D%22en-US%22%3EIntroducing%20Replication%20and%20Change%20Data%20Capture%20(CDC)%20for%20SQL%20Server%202017%20on%20Linux%20with%20CU18%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1063414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESQL%20Server%20Replication%20technology%20allows%20logical%20distribution%20and%20synchronization%20of%20data%20from%20one%20to%20one%20or%20many%20targets%20depending%20on%20requirement.%20CDC%20is%20data%20extraction%20and%20movement%20technologies%20which%20form%20backbone%20of%20many%20user%20scenarios%20and%20applications%20for%20users%20of%20SQL%20Server.%20One%20of%20the%20most%20frequent%20use-case%20for%20CDC%20is%20ETL%20services%20and%20applications.%20SQL%20Server%20team%20works%20with%20many%20users%20of%20SQL%20Servers%20who%20have%20deployed%20these%20technologies%20in%20critical%20and%20high-volume%20production%20servers%20all%20over%20the%20world.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWhen%20SQL%20Server%202017%20was%20introduced%20on%20Linux%20platform%2C%20the%20replication%20and%20CDC%20capabilities%20were%20unavailable.%20For%20many%20users%20of%20SQL%20Server%20who%20wanted%20to%20adopt%20SQL%20Server%20on%20Linux%20platform%2C%20unavailability%20of%20this%20feature%20was%20a%20limiting%20factor.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWith%20SQL%20Server%202019%2C%20we%20introduced%20support%20for%20replication%20and%20CDC%20features%20for%20SQL%20Server%20on%20Linux%20by%20bringing%20in%20relevant%20components%20and%20subsystems%20within%20SQL%20Server%20core%20engine%20package.%20This%20support%20includes%20Snapshot%20replication%2C%20Transactional%20replication%20and%20CDC.%20Peer-to-peer%20transactional%20replication%2C%20merge%20replication%20and%20Oracle%20publishing%20are%20not%20supported.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EToday%20we%20are%20glad%20to%20announce%20that%20we%20have%20brought%20the%20replication%20and%20CDC%20features%20to%20SQL%20Server%202017%2C%20starting%20with%20Cumulative%20update%2018%20(CU18).%20You%20can%20read%20more%20about%20how%20to%20configure%20replication%20and%20CDC%20via%20following%20documentation%20links.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4532751%2Fimprovement-snapshot-replication-and-transactional-replication-are-ena%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4532751%2Fimprovement-snapshot-replication-and-transactional-replication-are-ena%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Flinux%2Fsql-server-linux-replication%3Fview%3Dsql-server-linux-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Flinux%2Fsql-server-linux-replication%3Fview%3Dsql-server-linux-2017%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Ftrack-changes%2Fabout-change-data-capture-sql-server%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Ftrack-changes%2Fabout-change-data-capture-sql-server%3Fview%3Dsql-server-2017%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEngineering%20lead%3A%20Mike%20Habben%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEngineering%3A%20Alexander%20Vorobyov%3B%20Ben%20Ko%20%3B%20Dylan%20Gray%20%3B%20Ethan%20Moffat%20%3B%20Kapil%20Thacker%20%3B%20Madeline%20MacDonald%20%3B%20Mitchell%20Sternke%20%3B%20Val%20Menn%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETejas%20Shah%2C%20Principal%20program%20manager%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1063414%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20SQL%20Server%202019%20is%20all%20over%20the%20news%2C%20SQL%20Server%202017%20continues%20to%20introduce%20new%20capabilities%20to%20reduce%20functional%20gap%20between%20SQL%20Server%202017%20on%20Linux%20and%20SQL%20Server%202017%20on%20Windows.%20See%20what's%20new%20with%20cumulative%20update%2018%20(CU18).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1063414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

SQL Server Replication technology allows logical distribution and synchronization of data from one to one or many targets depending on requirement. CDC is data extraction and movement technologies which form backbone of many user scenarios and applications for users of SQL Server. One of the most frequent use-case for CDC is ETL services and applications. SQL Server team works with many users of SQL Servers who have deployed these technologies in critical and high-volume production servers all over the world.

 

When SQL Server 2017 was introduced on Linux platform, the replication and CDC capabilities were unavailable. For many users of SQL Server who wanted to adopt SQL Server on Linux platform, unavailability of this feature was a limiting factor.

 

With SQL Server 2019, we introduced support for replication and CDC features for SQL Server on Linux by bringing in relevant components and subsystems within SQL Server core engine package. This support includes Snapshot replication, Transactional replication and CDC. Peer-to-peer transactional replication, merge replication and Oracle publishing are not supported.  

 

Today we are glad to announce that we have brought the replication and CDC features to SQL Server 2017, starting with Cumulative update 18 (CU18). You can read more about how to configure replication and CDC via following documentation links.

 

https://support.microsoft.com/en-us/help/4532751/improvement-snapshot-replication-and-transactional-...

 

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-replication?view=sql-server-linux-2017

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sq...

 

Thanks,

Engineering lead: Mike Habben

Engineering: Alexander Vorobyov; Ben Ko ; Dylan Gray ; Ethan Moffat ; Kapil Thacker ; Madeline MacDonald ; Mitchell Sternke ; Val Menn

Tejas Shah, Principal program manager