Canonical: https://molo17.com/blog/gluesync-1-5-mssql-cdc-update/ Markdown mirror: https://molo17.com/blog/gluesync-1-5-mssql-cdc-update/index.md Title: Gluesync 1.5: Enhanced Microsoft SQL Server CDC for Advanced Data Synchronization Description: Explore the latest update in Gluesync 1.5 featuring enhanced CDC capabilities for Microsoft SQL Server. Discover how this significant shift from Change Tracking to CDC offers detailed data capture, improved data integrity, and versatile data handling for complex data migration and real-time analytics [← All articles](/blog/) Article # Elevating Data Synchronization: Gluesync’s Enhanced CDC for Microsoft SQL Server in Version 1.5 13 Nov 2023 [Gluesync](/blog/?category=gluesync) 3 min read Microsoft SQL Server CDC is now GA with Gluesync 1.5 Gluesync\\’s latest version 1.5 brings a pivotal enhancement for Microsoft SQL Server users: the introduction of Change Data Capture \[…\]  ## Microsoft SQL Server CDC is now GA with Gluesync 1.5 [Gluesync\\’s latest version 1.5](\"https://molo17.com/en/2023/11/introducing-gluesync-1-5-advancements/\") brings a pivotal enhancement for Microsoft SQL Server users: the introduction of Change Data Capture (CDC), a significant shift from the previously used Change Tracking (CT) method. **Background** Gluesync has consistently provided robust solutions for real-time data synchronization across various databases. While earlier versions relied on Change Tracking for Microsoft SQL Server, they faced limitations, especially in handling tables without primary keys. **The New Update – MS SQL Server CDC in Version 1.5** Version 1.5 marks a technological leap by incorporating CDC for Microsoft SQL Server. This feature is particularly adept at managing data synchronization tasks, even when tables lack primary keys. **Benefits of Using CDC with Microsoft SQL Server** 1. **Detailed Data Capture**: CDC offers an extensive history of data changes, capturing every insert, delete, and update in a comprehensive manner. 2. **Enhanced Data Integrity and Accuracy**: It tracks detailed change histories, ensuring high data integrity and accuracy. 3. **Comprehensive Data Synchronization**: CDC provides richer data sets for synchronization, capturing a full copy of the table along with metadata. 4. **Suitability for Complex Applications**: With its detailed tracking, CDC is ideal for applications requiring in-depth data analysis, like auditing and historical data analysis. 5. **Versatility in Data Handling**: CDC\\’s ability to work with tables without primary keys makes it a more versatile and capable tool. **Implementing CDC in Gluesync 1.5**  From Gluesync official documentation page: architecture example of MS SQL Server database using native CDC APIs to get real-time changes feed. Details about implementing CDC in Gluesync 1.5 can be found inside the official Gluesync documentation, which offers comprehensive guidance on setting up CDC with Microsoft SQL Server. You can find detailed information there, including technical setup, configuration steps, and other essential guidelines. Documentation is available here at the following link: [Gluesync 1.5 – Setting up CDC for Microsoft SQL Server](\"https://molo17.com/gluesync/docs/gluesync/v1.5/sql-to-nosql-source-microsoft-sql-server/setup-mssql-cdc.html\")​[](text=URL%3A%20https%3A%2F%2Fmolo17.com%2Fgluesync%2Fdocs%2Fgluesync%2Fv1.5%2Fsql\")​. **Real-world Applications** In the realm of complex data migration projects, Gluesync 1.5’s CDC capability shines by ensuring that every incremental change in the source Microsoft SQL Server database is accurately captured and replicated in the target system. This level of detail is crucial for maintaining data consistency during migrations, especially in dynamic environments where data changes frequently. Additionally, for real-time analytics, CDC’s comprehensive data capture enables more nuanced and up-to-date analysis, as every change in the database is immediately available for analytical processing, providing businesses with real-time insights that can drive informed decision-making. **Challenges and Solutions** Our CDC engine does not limit itself to just sourcing real-time data changes: we designed it also to outperform in bi-directional sync processes. You may already know that, unlike other data replication solutions, Gluesync provides a fully integrated high-performant bi-directional sync capability, and this new source connector also implements the same proving recursion loop barriers that are not so easy to achieve right out of the box. Another big achievement made by Gluesync\\’s engineering team! Gluesync 1.5\\’s integration of CDC for Microsoft SQL Server represents a significant advancement in data synchronization technology. This update enhances flexibility and efficiency and opens new frontiers in data management and analysis for MS SQL Server users. ### **Why MOLO17** MOLO17 is the reference partner for NoSQL solutions and has developed several projects using such technologies. Our mission is to ease the adoption of NoSQL databases with a safe & smooth approach providing a comprehensive set of features out-of-the-box: real-time event-driven, no third-party tools dependency, high-availability, and high-throughput approach. #### **About MOLO17** MOLO17 securely unlocks enterprise data potential with no downtime and no impact on business continuity. MOLO17 products and solutions offer the best of NoSQL database technologies to guarantee always-available consistent data and quality outcomes for mission-critical applications, whether in the cloud, on-premise, or for all types of mobile devices. ### Get in touch with us Want to get in touch with us? Drop us a line writing at [hello@molo17.com](\"mailto:hello@molo17.com\"). [← Older article Unveiling Gluesync 1.5: A Leap Forward in Data Synchronization](/blog/introducing-gluesync-1-5-advancements/) [Newer article → Introducing the New PostgreSQL CDC (WAL-based) Connector in Gluesync 1.5](/blog/introducing-the-new-postgresql-cdc-wal-based-connector-in-gluesync-1-5/) ## Keep reading 1. [Gluesync Chronos chained events: multi-step workflow orchestration for real-time pipelines Evolve your data scheduling with Chronos chained events. Orchestrate multi-step pipeline sequences like historical snapshots followed by real-time CDC with built-in RBAC controls. 6 Aug 2026](/blog/chronos-chained-events-workflow-orchestration/) 2. [Gluesync Query Forge: cross-database federated SQL querying without data movement Query Forge turns Gluesync Core Hub into a secure federated SQL gateway. Run cross-database JOINs across remote agents using a dedicated JDBC driver with zero data movement. 5 Aug 2026](/blog/query-forge-federated-sql-querying/) 3. [Gluesync Gluesync 2.2.10: federated SQL querying with Query Forge, advanced scheduling in Chronos and redesigned Control Plane Gluesync 2.2.10 transforms real-time replication into a unified data platform. Discover Query Forge federated SQL, Chronos event chaining, new UI and security enhancements. 28 Jul 2026](/blog/gluesync-2-2-10-query-forge-chronos-pipeline-wizard-ui/) [Back to all articles](/blog/) [More in Gluesync →](/blog/?category=gluesync)