This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Moving from LAN connection to WCF

Question
0

Sign in to vote

We developed an app that synchronizes a central SQL2008R2 db with many SQL CE daatabases. Now we'd like to make this work over WCF so our out-of offce people don't have to use a VPN connection. What is the best way to proceed?

If I add a "Local Database Cache" item to the solution it tells me that "SQL Server change tracking isn't enabled for table..." although of course, it is. I'm afraid to let it change my currently working setup. I did an export of the entire db to another db so that I could test with it and enabled SQL change tracking, however the wizard doesn't show me any tables in that db.

Wednesday, October 13, 2010 9:21 PM

Answers

0

Sign in to vote
Hi Mike,

We have a couple of different blog posts that can help walk you though this. Given that it sounds like you are using the VS Tooling, you should check out...

http://blogs.msdn.com/b/sqlblog/archive/2010/04/19/step-by-step-n-tier-configuration-of-sync-services-for-ado-net-2-0.aspx

Cheers,

Mike Clark

Group Manager

Microsoft Sync Framework
- Proposed as answer by Michael Clark [MSFT]Microsoft employee Thursday, October 14, 2010 12:27 AM
- Marked as answer by Sid Singh [MSFT]Microsoft employee Monday, October 18, 2010 6:18 PM
Thursday, October 14, 2010 12:26 AM

All replies

0

Sign in to vote
Hi Mike,

We have a couple of different blog posts that can help walk you though this. Given that it sounds like you are using the VS Tooling, you should check out...

http://blogs.msdn.com/b/sqlblog/archive/2010/04/19/step-by-step-n-tier-configuration-of-sync-services-for-ado-net-2-0.aspx

Cheers,

Mike Clark

Group Manager

Microsoft Sync Framework
- Proposed as answer by Michael Clark [MSFT]Microsoft employee Thursday, October 14, 2010 12:27 AM
- Marked as answer by Sid Singh [MSFT]Microsoft employee Monday, October 18, 2010 6:18 PM
Thursday, October 14, 2010 12:26 AM
0

Sign in to vote

Perfect! Thanks Michael. I knew it had to be out there somewhere.

Thursday, October 14, 2010 10:13 PM
0

Sign in to vote

Now for a twist on this question... I originally coded the app using SyncOrchestrator which I understand is a newer (preferable?) approach to using SyncAgent? It doesn't seem that SyncOrchestrator can use ServerSyncProviderProxy for the remote provider. Am I stuck with changing my code from SyncOrchestrator to SyncAgent or have I missed something?

Thanks!

Mike

Monday, October 25, 2010 7:39 PM
0

Sign in to vote

here's a sample using SyncOrchestrator and WCF, you just have to separate the WCF service: http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3423

Tuesday, October 26, 2010 12:37 AM