I want to SYNC the data on the server to the client, but never the client data to the server.
Is such a configuration possible with Merge Replication under SQL CE?
Thanks again!
Merge is designed to be bidirectional but RDA is intended for scenarios like yours.
Remote Data Access (RDA) with tracking turned OFF on your SQL Mobile tables is the way to solve this. You already have the IIS infrastructure in place since you're doing merge today. RDA pull the data to SQL Mobile on some schedule that supports the way your mobile users operate.
-Darren
|||
If you are talking about SQL Mobile 3.0 and SQL Server 9.0. YES :)
Choose the article type as "Download Only". This way you always get changes from SQL Server down to SQL Mobile. However, your changes in SQL Mobile will not be sent to SQL Server.
Useful MSDN URL: http://msdn2.microsoft.com/en-us/library/ms147295.aspx
Thanks,
LaxmI NRO, MSFT, SQL Mobile, Microsoft Corporation
No comments:
Post a Comment