RE: Comments on Merge Replication/RDA

From: Brad Syputa - MS (bradsy_at_Online.Microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 17:49:34 GMT

Different publications in same database are not supported. You could try 3
different publications with 3 different local databases.
--------------------
| From: "albert" <silencer8@remove-this.rocketmail.com>
| Subject: Comments on Merge Replication/RDA
| Date: Mon, 19 Jul 2004 11:36:12 +0800
| Lines: 40
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <eWcT8#TbEHA.1548@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.ce
| NNTP-Posting-Host: 219.94.124.114
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXS01.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:12889
| X-Tomcat-NG: microsoft.public.sqlserver.ce
|
| Hi all,
|
| I am currently developing a data collection system using VB6/MS SQL 2000
as
| frontend and VB .Net CF/MS SQL CE as backend for handheld devices.
|
| User will use the handheld to collect data and at the end of the day, will
| sync the data to SQL server. The collected data will then be deleted from
| handheld (to preserve memory). Basically, user has the option to perform
| following task from DESKTOP:
| 1)download data (from handheld to desktop)
| 2)upload selected data (from desktop to handheld)
| 4)Sync selected data (uses different tables from (1) and (2))
| 3)delete data in handheld
|
| Though not mention in SQLCE Online Books, many gurus confirmed that SQL CE
| does not support multiple subsribers in handheld. So, my initial plan to
| have 3 different publication for 3 different purpose (download, upload,
sync
| data) failed.
|
| The only option for me now is either RDA or merge replication or maybe
| combining both methods.
|
| Here is my plan.
| 1) for download process, i use a merge replication with the ExchangeType =
| Upload
| 2) for upload data, i use RDA where i have additional table for each table
| affected. Say, if i have a Customer table i will create another table call
| SyncCustomer. So, records selected from Customer table will be dumped into
| SyncCustomer before calling RDA process to PULL data to SQL CE.
| 3) for sync data, i use RDA where the concept will be the same as (2)
|
| Is this the best method or is there anything else i miss here??
|
| I welcome any comments and suggestions.
| Thanks
|
|
|
|
|
|

Relevant Pages

  • Re: SQL CE Memory Issue
    ... I can tell you that with both SQL CE and SQL Mobile on databases around 1-20 ... I have not seen any memory issues at all with replication or RDA. ...
    (microsoft.public.sqlserver.ce)
  • Re: Identity column, I use RDA
    ... I second that suggestion - identity ranges in replication or RDA ... > You can use column primary key identity with auto increment, but on SQL Ce ... >>> a patient tabel where data is pulled from SQL table with tracking on ...
    (microsoft.public.sqlserver.ce)
  • Comments on Merge Replication/RDA
    ... I am currently developing a data collection system using VB6/MS SQL 2000 as ... User will use the handheld to collect data and at the end of the day, ... The only option for me now is either RDA or merge replication or maybe ...
    (microsoft.public.sqlserver.ce)
  • Comments on Merge Replication/RDA
    ... I am currently developing a data collection system using VB6/MS SQL 2000 as ... User will use the handheld to collect data and at the end of the day, ... The only option for me now is either RDA or merge replication or maybe ...
    (microsoft.public.dotnet.framework.compactframework)
  • Comments on Merge Replication/RDA
    ... I am currently developing a data collection system using VB6/MS SQL 2000 as ... User will use the handheld to collect data and at the end of the day, ... The only option for me now is either RDA or merge replication or maybe ...
    (microsoft.public.sqlserver.programming)