Category Sync Framework

Synchronizing WinRT/SQLite using Sync Framework Toolkit

It’s been a while since my last blog post and it’s been a while since I started to write this post and a couple of more that’s been eternally in draft mode. So, let me tackle a common question I often see in forums and I get ask personally: Database synchronization for WinRT/SQLite based applications. […]

Things You Need To Know About SQL Data Sync Service

The following is a collection of the things I’m usually asked, things that I usually encounter and clarify in forums and some other little known facts. So, I thought I’d post it here and just update it from time to time. 1. Provisioning Before a member database can participate in synchronization, the Data Sync Service […]

Sync Framework Hotfixes (Updated: June 14, 2012)

KB article number Description 2703853 FIX: "System.OverflowException: Value was either too large or too small" error message when you perform data synchronization by using Sync Framework 2.1 2535671 FIX: ChangesApplied event incorrectly occurs before a change that is in a retry queue is applied to a database in a Sync Framework 2.1-based application Fixes an […]

SQL Server Compact Toolbox Sync Framework support

Erik (blog | twitter)  has just recently blogged that the Preview of SQL Server Compact Toolbox version 3.0 is now available. SQL Server Compact Toolbox  is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to […]

Sync Framework and SQL Compact 4 (Yes, You Can!)

Inspired by Erik’s Using LINQ to SQL with SQL Server Compact 4.0 (yes, you can!) blog post, here’s how you make Sync Framework work with SQL Compact 4.0 While the Microsoft documentation is very clear in stating that Replication and Synchronization is not supported in SQL Compact 4, it’s not uncommon to see questions on […]