SQL Server DB to the Cloud with SQL Data Sync

If you want to syncronize your local SQL Server Database with a Database in the SQL Azure Cloud, you can start using the SQL Data Sync that allows you to implement bi-directional data synchronization. First you need to download the Microsoft Synch Framework 2.0 Software Development Kit (SDK) from this address

http://www.microsoft.com/downloads/details.aspx?FamilyID=89adbb1e-53ff-41b5-ba17-8e43a2e66254&displaylang=en

Then you need to download the actual SQL Data Sync CTP from http://www.microsoft.com/downloads/details.aspx?FamilyID=bce4ad61-5b76-4101-8311-e928e7250b9a&displaylang=en

One you have installed both applications you will be able to run the SQL Data Sync Wizard as shown in the following steps:

 

1. First you need your SQL Azure server Address and Password, also you need to specify the name of the database that you want to replicate the data to, in this case is AdventureWorks that resides in SQL Azure. If you need you SQL Azure information you can access your account in the SQL Azure Portal in this address http://www.microsoft.com/windowsazure/sqlazure/ remenber that you need to configure the firewall in the SQL Azure Portal Page to allow the traffic beetween you local server and the cloud.

image

2. Next you need to specify you local database information

image

3. In the next step you will need to specify which tables will be syncronized, review the Conflict Resolution Policy, this allows you to specify how the the conflicts will be handled.

image

4. After that you can specify the order of the tables, and in the final step the summary will be shown:

image

5. Now you can click on Process to run the syncronization.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Comments

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

Permitiendo la administración de los jobs a usuarios que no son System Administrators en SQL Server Agent 2005 o superior

FileTable en SQL Server 2012