Project Description
A console application that does a synchronization between a database on-premise  and Windows Azure SQL Database. This application uses the excellent and very efficient Microsoft Sync Framework

Synchronization Configuration

The synchronization is detailed in the configuration file, so it's really easy to setup, change, and update with out re-compiling.  In the configuration file you will define:  

Here a sample of a configuration file

<configuration>
  <connectionStrings>
    <add name="LocalConnectionString" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=MyLocalDatabase;Integrated Security=True"/>
    <add name="CloudConnectionString" connectionString="Server=tcp:aaaaaaaa.database.windows.net,1433;Database=MyDatabaseName;User ID=MyAdmin@aaaaaaaa;Password=MyPassword;Trusted_Connection=False;Encrypt=True;"/>
  </connectionStrings>
  <appSettings>
    <add key="SyncScopeName" value="Test"/>
    <add key="TablesToSync" value="Table1,Table2"/>
    <add key="DaysOfRetention" value="30"/>
  </appSettings>
</configuration>

 

Using the application

The application may be called by passing different parameter :

 

Simple call

UniSync.exe -sync


Note :
If no parameter is passed then sync as the default synchronization is taking place.