{"id":761,"date":"2007-09-21T21:44:00","date_gmt":"2007-09-21T21:44:00","guid":{"rendered":"\/blogs\/bobb\/post\/Sync-Services-and-SQL-Server-2008-Change-Trackinga-perfect-match.aspx"},"modified":"2013-01-04T00:01:21","modified_gmt":"2013-01-04T08:01:21","slug":"sync-services-and-sql-server-2008-change-tracking-a-perfect-match","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/","title":{"rendered":"Sync Services and SQL Server 2008 Change Tracking&#8230;a perfect match?"},"content":{"rendered":"<p>\nJust saw <a href=\"http:\/\/sqlblog.com\/blogs\/aaron_bertrand\/archive\/2007\/09\/21\/elaborations-on-my-sql-server-2008-slides.aspx\" class=\"broken_link\">Aaron Bertrand&#39;s post<\/a> from PASS on SQL Server 2008 Change Tracking vs Change Data Capture (change data capture (or&nbsp;CDC)&nbsp;is in the current CTP; change tracking is not). I&#39;m not at PASS this week myself, but home while the house is being re-roofed.&nbsp;His post seems to confirm something I&#39;d suspected all along.\n<\/p>\n<p>\nChange tracking seems to go hand-in-hand with Sync Services for ADO.NET. I&#39;ve been following <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=16515\" class=\"broken_link\">Sync Services<\/a> for a while; it&#39;s a set of libraries for controlling and implementing synchronization for disconnected database applications. Its current shipping vehicle is the Visual Studio Orcas Beta 2 release, along with SQL Server Compact Edition version 3.5.&nbsp;The fact that SQL Server 2008 Change Tracking provides a mechanism to keep track of which user (the sync OriginatorID) made a change (CDC doesn&#39;t) and also seems to provide automatic change table management for DELETEs (CHANGE_RETENTION) and a mechanism to &quot;get the set of changes that have occured from a baseline&quot; (the &quot;sync_last_received_anchor&quot; in sync services) makes Change Tracking line right up with what Sync Services requires.\n<\/p>\n<p>\nAlthough Aaron mentions &quot;offline stores like Outlook in cache mode&quot;, SQLCE is an exciting offline store because&nbsp;its currently deployed in places like Windows Media Player, Zune, Media Center PC, and more. SQLCE runs on mobile devices and desktops. Sync Services isn&#39;t available for mobile devices yet, but is said to be &quot;in progress&quot;.\n<\/p>\n<p>\nWhen you set up a Sync Service app, you currenly must make changes to the database (triggers, &quot;tombstone tables for deletes&quot;, and such)&nbsp;referred to by the &quot;ServerProvider&quot;, in order to track the information Sync needs. The Sync &quot;ServiceProvider&quot; architecture layers over\/shares concepts with&nbsp;the ADO.NET provider model.&nbsp;But you don&#39;t have to make changes for the SQLCE 3.5-side (SQLCE is the only current &quot;ClientProvider&quot; that Sync Services supports) because, &quot;support for sync is built in&quot;. Well&#8230;maybe it&#39;s built in to the server too, with SQL Server 2008. Bet we&#39;ll see (at least one) demo with Sync Services when the Change Tracking feature ships.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just saw Aaron Bertrand&#39;s post from PASS on SQL Server 2008 Change Tracking vs Change Data Capture (change data capture (or&nbsp;CDC)&nbsp;is in the current CTP; change tracking is not). I&#39;m not at PASS this week myself, but home while the house is being re-roofed.&nbsp;His post seems to confirm something I&#39;d suspected all along. Change tracking [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,32],"tags":[],"class_list":["post-761","post","type-post","status-publish","format-standard","hentry","category-sql-server-2008","category-sql-server-compact-edition"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"Just saw Aaron Bertrand&#039;s post from PASS on SQL Server 2008 Change Tracking vs Change Data Capture (change data capture (or&nbsp;CDC)&nbsp;is in the current CTP; change tracking is not). I&#039;m not at PASS this week myself, but home while the house is being re-roofed.&nbsp;His post seems to confirm something I&#039;d suspected all along. Change tracking [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2007-09-21T21:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-04T08:01:21+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/\",\"name\":\"Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2007-09-21T21:44:00+00:00\",\"dateModified\":\"2013-01-04T08:01:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2008\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Sync Services and SQL Server 2008 Change Tracking&#8230;a perfect match?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/","og_locale":"en_US","og_type":"article","og_title":"Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin","og_description":"Just saw Aaron Bertrand&#39;s post from PASS on SQL Server 2008 Change Tracking vs Change Data Capture (change data capture (or&nbsp;CDC)&nbsp;is in the current CTP; change tracking is not). I&#39;m not at PASS this week myself, but home while the house is being re-roofed.&nbsp;His post seems to confirm something I&#39;d suspected all along. Change tracking [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/","og_site_name":"Bob Beauchemin","article_published_time":"2007-09-21T21:44:00+00:00","article_modified_time":"2013-01-04T08:01:21+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/","name":"Sync Services and SQL Server 2008 Change Tracking...a perfect match? - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2007-09-21T21:44:00+00:00","dateModified":"2013-01-04T08:01:21+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/sync-services-and-sql-server-2008-change-tracking-a-perfect-match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-server-2008\/"},{"@type":"ListItem","position":3,"name":"Sync Services and SQL Server 2008 Change Tracking&#8230;a perfect match?"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=761"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/761\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}