We are developing a embedded system based on Windows CE 5 and SQL Server CE 3 in C++ where we need to do merge replication in background while the front end application still need to perform operations on the database. A solution would be to run the merge replication on a separate thread while the application thread still can access the database to do inserts and updates. I have been researching if it is possible to access the database with queries during a merge replication, but I can not find an answere. Does anyone have experience of this and generally know if it is possible to implement with SQL Server CE 3 in the native API?
Best regards
Johan Johansson
This article may help you understand the implications of a user trying to access SQL Mobile while merge replication is happening.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5mobilesynch.asp
Darren
|||Thanks Darren, this is exactly what I was looking for.
Best regards
Johan
No comments:
Post a Comment