The Synchronizer

sync for the masses

Browse by Tags

Tagged Content List
  • Blog Post: What’s new in Sync Services for ADO.NET 2.0?

    As you know we’ve released the V1.0 of Sync Services for ADO.NET as a standalone package. It is also bundled with Visual Studio 2008 with additional Sync Designer experience. Sync Services is one component in a comprehensive sync platform offering from Microsoft called Microsoft Sync Framework that we...
  • Blog Post: Stay Away From Auto Increment Columns

    I had few conversations on the sync services forum about that ability to synchronize a table with auto-increment column, also known as identity column, as the primary key or unique id for the row. It is rather common to see this pattern of primary key set to auto increment integer type in every table...
  • Blog Post: Sync Events for Conflict Handling, Progress Reporting, Business Logic …

    Let me just say that synchronization services eventing model is so rich. It is designed to enable you to build many of the features that business applications demand. Some of those features that come to mind are: Monitoring and progress reporting Conflict detection and resolution Tracing...
  • Blog Post: Avoiding False Conflicts Resulting From Interrupted Sync

    A great thread on the sync services forum yesterday brought up this interesting question on what happens if the sync session is interrupted due to connection failure or client application crash …etc. To visualize the scenario in your mind, picture an n-tier sync app which uses a web service to upload...
  • Blog Post: Sync Services: When should you author your own table schema for your offline clients?

    The question of creating the schema on the client store always pops up in almost any sync related conversation. Flexibility is desired but simplicity is a must! I can understand that and I believe that the sync framework has a good balance between both (feel free to tell me otherwise)… In one of my...
  • Blog Post: Sync Services: How to partition data for your offline clients?

    Offline clients are not born equal; one client would like to sync a lot of server data while another client might just wish for its small share of rows that pertains to the task at hand. Sync services framework recognizes the need for data partitioning and so in this post I’ll try to give some details...
  • Blog Post: Deep in Sync: Handling PK-FK Constraints

    Roger Jennings in his most recent blog post asked an interesting question on how sync services deal with one-to-many relationship between tables undergoing synchronization? Roger is the most active blogger I know of and he is watching sync services closely. It is no secret that his blogs is one of my...
  • Blog Post: Sync Services: Thoughts on Schema Creation

    In typical database to database sync scenarios where the backend database is SQL Server, the sync framework creates the schema for the tables undergoing synchronization on the client database. All that is needed is to have the SelectIncrementalInsertsCommand or SelectIncrementalUpdatesCommand supplied...
  • Blog Post: A nice gift from SQL Server 2005 SP2 to sync developers

    If you haven’t heard the news yet, SQL Server 2005 SP2 is out! Now if you are like me, thinking about data synchronization for the most part of your day, then you should be really excited about SP2. Let me tell you why. Recall that in all sync services demos in this blog, we used timestamp tracking column...
  • Blog Post: Sync Services: What can SyncAnchor do for you, today?

    If you had time to browse the documentation for Synchronization Services for ADO.NET , you might have seen a class called SyncAnchor. You don’t deal with it directly and none of the demos in my blog interact with it directly except the server command called GetNewAnchor which returns a new timestamp...
  • Blog Post: Sync Services: Periodic Tombstone Cleanup

    One of the important topics in data synchronization is managing metadata used to track changes on the store. Just a quick reminder of the different kinds of metadata used in the demos so far: Adding inline columns to each table we plan to synchronize. Sync services runtime along with database triggers...
  • Blog Post: Synchronization Services for ADO.NET Vs SQL Merge Replication

    One of the common questions I get from developers once they get their hands on the new sync framework for ADO.NET is: How is it different from SQL Merge Replication? When should I use merge as oppose to sync services? Can sync services do filtering, ddl replication etc …? These are all interesting questions...
Page 1 of 1 (12 items)