MS Sync Framework: synchronize 1 client DB with 2 server databases -


working on connected application on windows mobile devices. application stores data locally in sql ce database synced mssql db using ms sync framework (via web service).

now it's necessary sync mobile db 2 different server databases. i.e. sql ce database has tables a,b,c. tables , b should synced tables , b on serverdatabase1, , table c should synced table c on serverdatabase2.

i'm thinking of creating second set of sync objects (syncagent , syncprovider) used syncing second database. wondering if there's other more convenient way this.

that should work long you're synching same table same server. i.e., table c synched table c in serverdatabase2.

the sync provider you're using has table contains "anchors" every table sync. anchors last sent , last received timestamps (if you're using timestamps). there's 1 row each table, cannot keep track of sync status of each table against multiple sync partners.

a received anchor server different anchors in server b. break if sync same table server , sync server b


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -