Re: SQL Mobile and MSDE

No, not "out of the box". A product such as Odyssey's CEFusion[1] may be helpful, but it utilizes a different model for data synchronization.

The only fully supported Oracle synchronization solution I know of is use to Oracle Lite (instead of SQL CE) on the device. Otherwise, you are looking at rolling your own synchronization / conflict resolution solution. I have seen this done before, putting ASP.NET Web Services in front of Oracle.

hth,
Nino

[1]http://www.odysseysoftware.com/cefusion_overview.asp

Wiredless wrote: 
The backend is Oracle

Can i do merge replication from PDA (SQL Mobile) to Oracle?

"Dennis Lorang" <DennisLorang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BD6CB1F5-F6B4-4FBD-ADD2-C5FAE1EBB4D8@xxxxxxxxxxxxxxxx

If the server is running SQL Server then I would sync the PDA to the server
with RDA and sync the laptop to the server. That takes MSDE out of the PDA
equasion. You may have to write some conflict resolvers depending on the
usage case.

"Wiredless" wrote:


Hi,



I' am trying to determine if i should use CF 1.x with SQL CE 2.0 and MSDE for a new application or CF 2.0 with SQL Mobile and MSDE. I have been told that I cannot use merge replication with SQL Mobile and MSDE. So, I will need to create my own custom DB synchronization system. I was told that the solution MUST use MSDE since the client already has an application using this but with laptop computers. They want to have both the laptop solution and pocket pc solution.



With that said I have a few questions that should help me decide.



I heard from microsoft that CF 2.0 is not really beta that it is really a final product. Is this also true for Sql Mobile under beta 2?



Is there a "Go Live" license for VS 2005 Beta 2 that will allow me to deploy the system for internal sales force use?



Do you know of any replication/synchronization solutions that currently support SQL Mobile to MSDE on a notebook?



Just as MSDE is the desktop version of SQL Server 2003 is there a desktop version of SQL Server 2005 (MSDE 2005) ?



If there is a MSDE 2005 will it work with SQL Mobile for replication and synchronization?



Also, any advice on the best synchronization model for a 3 tierd sync system. in other words. I have a server a laptop and pocket pc. I can either sync the pda to the laptop and the the laptop to the server or I can sync the laptop to the server and the pda to the server. I thought it would be best to sync the pda to the laptop then the laptop to the server this way the pda will sync to the laptop which will have a subset of the rows in the various tables. Otherwise the pda will sync to the larger tables on the server which seem like a slower and possible more complex task.



Sorry for so many question. Any help would be greatly appreciated.



Thanks






.

Relevant Pages

  • Re: Replication between sql2k, MSDE and ce
    ... I changed the same column of the same row on the PDA, ... and showed up in the MSDE tables. ... Sql Server CE 2.0 ... synchronization would be greatly appreciated; we have a work around that ...
    (microsoft.public.sqlserver.ce)
  • Re: Help! Outlook 2002 Stopped Receiving Email
    ... the server and desktop are synchronized. ... they are then synchronized by the Outlook Connector. ... This synchronization supports the ... Am in the process of moving everything to my laptop so that I can put ...
    (microsoft.public.outlook)
  • Re: MSDE login problem - URGENT.
    ... Enterprise manager on my notebook can connect to MSDE. ... And the server is registered in EM with sa / 123 as opposed to using Windows ... laptop, I guess) and go into Properties, then select the Security tab. ...
    (microsoft.public.vb.general.discussion)
  • Merge process unable to add subscription
    ... I have a Windows 2003 server and MSDE 2000 with published database. ... When I am installing the App on a laptop, I get the above error to ... I use the user account as 'This account' in logon ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication to laptops - how do you do this?
    ... We have a main office which has the server. ... out in the field gathering information into the replica. ... So I don't know which is the best synchronization method to use. ... each laptop needs to have a replica of the data file. ...
    (microsoft.public.access.replication)