This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Sync Sql Azure Data With Sql Express

Question
0

Sign in to vote

hey...can you please tell me how to sync sql azure with sql express. i want to sync the Contents with Stored Procedures which would filter the data and give it to sync framework and then sync framework will save that filtered data into clients DB.

Is it possible? can you please give me some sample code as soon as possible.

Thursday, February 11, 2010 12:24 PM

Answers

0

Sign in to vote
In general you need to install Sync Framework V2 and Sync Framework Power Pack for SQL Azure November CTP (32-bit). There are also 2 sample code you can reference SQL to SQL Express and SQL to SQL compact.

When you are doing sync between SQL Azure and SQL Express, you should have 2 provider instantiated. One is SQL Azure Provider and another one is SQL provider (with a connection string pointing to the SQL express server).

Thanks.

Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)
http://www.microsoft.com/downloads/details.aspx?FamilyID=bce4ad61-5b76-4101-8311-e928e7250b9a&displaylang=en

Microsoft Sync Framework 2.0 Software Development Kit (SDK)
http://www.microsoft.com/downloads/details.aspx?FamilyID=89adbb1e-53ff-41b5-ba17-8e43a2e66254&displaylang=en

Database Sync - SQL Server and SQL Server Express
http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762

Database Sync - SQL Server and SQL Server Compact
http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422
Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
- Proposed as answer by L Zhou [MSFT]Editor Thursday, February 11, 2010 6:20 PM
- Marked as answer by Mahesh DudgikarMicrosoft employee Friday, February 19, 2010 5:42 AM
Thursday, February 11, 2010 6:20 PM

Answerer