SQL Server to SQL Azure Synchronization using Sync Framework 2.1

I have just posted a webcast to Channel 9 that shows you how to extend the capabilities of SQL Azure Data Sync by writing a custom sync applications to enable bi-directional data synchronization between SQL Server and SQL Azure.  This enables you to add customization to your synchronization process such as custom business logic or custom…

25

SQL Azure Data Sync Update

It’s been a while since we announced SQL Azure Data Sync CTP2 and I wanted to provide an update on how CTP2 is progressing as well as an update on the service in general. Late last year at PDC we announced CTP2 and started accepting registrations for access to the preview release.  In mid-December we…

19

How to Sync Large SQL Server Databases to SQL Azure

Over the past few days I have seen a number of posts from people who have been looking to synchronize large databases to SQL Azure and have been having issues.  In many of these posts, people have looked to use tools like SSIS, BCP and Sync Framework and have run into issues such as SQL…

14

How to Synchronize Multiple Geographically Distributed SQL Server Databases using SQL Azure Data Sync

Imagine that you want to have multiple copies of the same SQL Server databases located in different locations around the country or even around the world. Those SQL Server databases could exist in your headquarters, subsidiaries, retail stores, and even in your remote offices.  Currently, to accomplish this, there are a number of really great…

13

Top New Features in Sync Services for ADO.NET v2

Today’s release of Microsoft Sync Framework includes the latest version of Sync Services for ADO.NET.  A great deal of work has gone into this release and I thought I would take some time to point out some of the top new features in version 2 since our previous release. Peer-to-peer synchronization support: Beyone the traditional…

13

Sample – SQL Express Client Synchronization using Sync Services for ADO.NET

We have just posted a new sync sample to our Code Gallery that demonstrates how to enable offline data collection applications to synchronize a SQL Express client database to another SQL Server database using the Synchronization Services for ADO.NET library.  In this scenario, SQL Express client databases can be used as client databases to a…

13

Announcing Sync Framework 4.0 October 2010 CTP

We are extremely happy to announce the availability of Sync Framework 4.0 October 2010 CTP. To learn more about this release please take a look at our PDC session recording “Building Offline Applications using Sync Framework and SQL Azure”. The Microsoft Sync Framework 4.0 October 2010 CTP is built on top of Sync Framework 2.1…


Sync Framework Toolkit now available for download

The Sync Framework Toolkit extends the Sync Framework capabilities for building offline applications, making it easier to expose data for synchronization to applications running on any client platform.  Sync Framework 2.1 required clients to be based on Windows. This toolkit allows other Microsoft platforms to be used for offline clients such as Silverlight, Windows Phone…


Sync Framework 2.1 Available for Download

Sync Framework 2.1 is available for download.   Sync Framework 2.1 includes all the great functionality of our 2.0 release, enhanced by several exciting new features and improvements. The most exciting of these lets you synchronize data stored in SQL Server or SQL Server Compact with SQL Azure in the cloud. We’ve added top customer…

11

Looking Forward – Offline Capable Applications Using SilverLight and Sync Framework

Right from the first release of Microsoft Sync Framework, one of the most common requests we have received is for the ability to take SilverLight applications offline, meaning that users can continue to access their applications and data regardless of connectivity to the backend web application. Using this architecture, developers can build much richer applications…

10