Hi,
Newbie Question
I have a scenario where SQL Server CE installations on smart clients
need to synchronize with two separate SQL Server DBs (residing in two
physically separate server machines). One server contains active
transactional data which will be modified by the clients also (hence,
bidirectional sync), while the other contains reference data which
changes infrequently and needs to be synced from the server to the
client(s).
Is it possible for CE to sync with multiple dbs using merge
replication?
Thanks,
Andy
ErikEJ - 12 Dec 2007 16:39 GMT
Yes, you can have multiple subscription in the same SDF file (a 3.0
feature).
And you have ReadOnly articles with SQL Server 2005 Merge publications (for
your reference data).

Signature
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com
> Hi,
>
[quoted text clipped - 13 lines]
> Thanks,
> Andy