Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / December 2007

Tip: Looking for answers? Try searching our database.

Synchronization with multiple SQL Server dbs?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy - 11 Dec 2007 22:12 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.