RE: Sync DB SQL Server CE and remote MySQL on internet
From: Darren Shaffer (DarrenShaffer_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: Darren Shaffer: "RE: TabControl Alignment in Compact Framework."
- Previous message: Darren Shaffer: "RE: RDA.PULL - No Table created on Device ??? URGENT HELP !!!"
- In reply to: Peter: "Sync DB SQL Server CE and remote MySQL on internet"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 09:53:04 -0700
Peter,
Safe to say there is no chance of native replication (RDA/Merge) from SQL CE
to mySQL coming in the future, however using an XML Web Services approach
from the Pocket PC client to the database server is your best bet for
achieving database-independent synchronization from mobile device to a DBMS
and back again. It puts more work on you to manage conflicts and concurrency
when multiple devices are synchronized, but it can be done very effectively
and I use this
model even for SQL Server database servers when the amount of data being
transferred is small (< 1MB).
Some tips:
1. make every entity that needs to be unique on the server and across all
PDAs a GUID.
2. use an outbox model on both ends - in other words, for every table that
contains replicatable entities, create an outbox that contains the GUID of
the entities that have changed on that end, and the next time a connection
exists, send copies of those entities the other direction
3. both ends can use a "delete and replace" algorithm to keep entities
current. of course you have to manage conflicts with locking/data currency
across multiple devices, but in most cases this is not too hard to figure out
rules for.
Good luck!
-Darren
"Peter" wrote:
> Hello EveryOne,
>
> Currently, i have a local db (SQL CE) in the PPC device and MySQL DB on the
> net. So far we sync both db using a mid application. However, in the future,
> we might remove the midapp so hopefully ppc will can sync directly from
> SQLCE to Online MySQL.
>
> Any idea how to achieve it?
>
> I really appriaciate any comment, helps and suggestion.
>
> thanks a lots.
>
> regards,
>
> Peter Alex
>
>
>
- Next message: Darren Shaffer: "RE: TabControl Alignment in Compact Framework."
- Previous message: Darren Shaffer: "RE: RDA.PULL - No Table created on Device ??? URGENT HELP !!!"
- In reply to: Peter: "Sync DB SQL Server CE and remote MySQL on internet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
