Re: Best Practices Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
The tables you refer as 'read only' on the device, can be defined as 'download only' in the publication, so there won't be any change tracking on those tables on the device. Also, suppose that during the day you want the subscribers to just upload new orders and not download any server side changes, you can define that behavior on the Replication object on the device.

In regards to the one SDF/multiple SDFs, we have one single SDF on a SFA tools with about 110 tables, up to 60mb on some customers, and Merge Replication fulfills our needs.

--

Alberto Silva
www.moving2u.pt - R&D Manager
http://msmvps.com/AlbertoSilva - Blog
Microsoft MVP - Device Application Development

"Michael P" <mipp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:eiBUCTXfJHA.5540@xxxxxxxxxxxxxxxxxxxxxxx
I am developing a SQL Server Compact 3.5 application that utilizes merge replication. Deployment will be to about 100 nodes.

I have about 10 tables that are included in the merge rep subscription. A few will change each day, resulting in small updates. These tables hold source data from the originating db and will never be updated at the client. This is an order entry system, so data will be passed back from other tables and will be done without merge replication. I will also have 10 to 15 application tables in the sdf to hold order data and other client specific stuff.

My question is should I separate the merge replicated read-only tables into one sdf, then put the read/write tables in another? I realize this is an open ended question, but since this is my first OCA with CE, I figured I'd seek some advice. I see some merits to that methodology, but wanted to ask the pros their opinion.



.

Relevant Pages

  • Best Practices Question
    ... This is an order entry system, so data will be passed back from other tables ... and will be done without merge replication. ... application tables in the sdf to hold order data and other client specific ... open ended question, but since this is my first OCA with CE, I figured I'd ...
    (microsoft.public.sqlserver.ce)
  • Re: OpenNetCF - Retrieving Latest Source
    ... We try and make available updated source packages on the SDF page on the ... The SourceBrowser can be used to download entire code files, ... > numbers from the source browser version, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQLCE Corrupt Database!!!
    ... On device memory or on a Storage card? ... Peter Foot ... > We have 5 .sdf databases on our handhelds. ... Then our replication monitor sends 9 back down. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Choosing the right embedded database.
    ... I may have been a bit hasty mentioning database replication. ... > Most users would download the application and data from a website via DIAL ... It also instantly scales to the full client server Firebird system. ...
    (borland.public.delphi.thirdpartytools.general)
  • Changing an article from download-only to bi-directional
    ... articles from download only to bi-directional. ... should I use sp_changemergearticle rather than SSMS? ... Merge replication with pull subscriptions using web synchronisation ...
    (microsoft.public.sqlserver.replication)