I am developing an application with Microsoft Sync Services. The server will be running SQL Server Express and there will be multiple clients running SQL Server CE.
I'm using SQL Server change tracking. Data to download is set to "New and incremental changes after first synchronization". I have a small demo application that lets me do inserts/deletes/updates on the client and on the server. It works perfectly fine when there's one client and one server, however, when there's multiple clients, it doesn't work properly.
If the serer makes an insert/delete/update, both clients are properly changed when synching.
If client 1 makes an insert/delete/update, and then synchs with the server, when client 2 synchs with the server, it does not receive the changes made in client 1.
If I make both clients set Data to Download be "Entire Table Each Time", then inserts get handled properly among clients, but updates/deletes do not. I'd also be worried about performance of downloading the entire table over a wireless connection when the table becomes large.
How can I get the changes in one client to be recognized by other clients?