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

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

Initiating Sync to SQL Azure using SQL

For those of you who have tried SQL Azure Data Sync you likely know that the way that we execute synchronization from SQL Server to SQL Azure is through the use of SQL Agent.  One of the handy parts of SQL Agent is the ability to schedule synchronization based our your own requirements.  However, in…

0

Sending Email Notifications Using SQL Azure Data Sync

I love to see when users take the products we have created and add extensions to it to suit their specific needs.  Earlier this week I talked about how Hilton Giesenow’s extended SQL Azure Data Sync to create a custom synchronization application using VB.NET to allow him to do custom conflict resolution and get better…

0

How to Synchronize from SQL Azure to SQL Server using Visual Basic

When we introduced SQL Azure Data Sync, one of the primary goals was to reduce the complexity of getting started with synchronization using the Sync Framework.  Using the “SQL Azure Data Sync Tool for SQL Server” users can launch a wizard that configures synchronization from an existing SQL Server to a new SQL Azure database. …

0

New Case Study – GoGrid and Blue Star Infotech

We recently added a new case study of a solution built by GoGrid on the Windows Azure platform to allow customers to develop, test, deploy, and back up Windows Azure applications.  GoGrid partnered with Blue Star Infotech, a global provider of IT and Outsourced Product Development services and solutions to build a solution that provides…

0

SQL Pass Conference & Synchronization to SQL Azure

Yesterday was the first day of the SQL Server conference, SQL Pass, here in Seattle.  It was a really exciting day for me because I had the opportunity to present our new synchronization capabilities to the cloud in the opening day keynote and in a subsequent session.  We introduced the first piece of Project “Huron”,…

0

Announcing Availability of Sync Framework v1 and Sync Services for ADO.NET v2

I am happy to announce the general availability of Sync Framework v1 and Sync Services for ADO.NET v2.  As of today you can download the Sync Framework SDK in 11 languages including Chinese (Hong Kong), Chinese (Simplified), English, German, French, Italian, Japanese, Korean, Portuguese, Russian and Spanish for AMD64, IA64 and x86 processors from the Sync…

6

Using SQL Server 2008 Integrated Change Tracking to Optimize Data Synchronization

I thought I would take the chance to talk to you a little bit about a major enhancements we have made with synchronization in SQL Server 2008.  The feature I am referrring to is called SQL Server 2008 Integrated Change Tracking.  The idea behind this feature is that it enables SQL Server to track data changes…

5

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