Synchronize SQL Server and SQL Azure using Sync Framework

In this Blog, I will discuss Synchronizing data between an On-Premise SQL Server database and a SQL Azure database in the Cloud using Microsoft Sync Framework. There are others ways of synchronizing data between On-Premise SQL Server databases and SQL Azure databases, but this blog is focused on using Microsoft Sync Framework and C# code to synchronize data….


Migrating an on-premise database from SQL Server to SQL Azure using SSIS

  In this blog I will demonstrate moving an on-premise SQL Server database to SQL Azure using SSIS. I will perform the tasks mentioned below: Provision the Destination SQL Azure Database Generate a DDL Script of the SQL Server Source Database Execute the DDL Script against SQL Azure Destination Database Use SSIS to export the…