This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Sync Sql Server CE 3.5 with SQL Server over internet

Question
0

Sign in to vote

Hi,

I have a SQL Server CE 3.5 C# application collecting asset data & wish to be able to sync a read only copy of the data to a remotely hosted SQL Server database. The server is owned by the company I work for so security etc is not an issue. Is it wise/acceptable to sync across the internet directly using the Microsoft Sync Framework 2.1 or should some sort of middle layer web service be used?

Any help appreciated.

Thanks

Paul.

Paul Wainwright

Friday, April 18, 2014 7:15 AM

Answers

0

Sign in to vote
you can do an n-tier setup with WCF in between instead of your client connecting directly to SQL Server.

have a look at this sample: Database Sync: SQL Server and SQL Compact N-Tier with WCF
- Marked as answer by pr_wainwright Friday, April 18, 2014 10:07 AM
Friday, April 18, 2014 9:46 AM

All replies

0

Sign in to vote
you can do an n-tier setup with WCF in between instead of your client connecting directly to SQL Server.

have a look at this sample: Database Sync: SQL Server and SQL Compact N-Tier with WCF
- Marked as answer by pr_wainwright Friday, April 18, 2014 10:07 AM
Friday, April 18, 2014 9:46 AM
0

Sign in to vote

Thanks for the link. Paul.
Paul Wainwright

Friday, April 18, 2014 10:07 AM