Re: Wireless Synchronization

Hi Beebs,

You have lot of options for synchronizing data.

Need to first choose whether you are going to sync data with your
desktop database and PPC database. If you are using SQL Server you have
options like

1. Directly Querying SQL Server using SqlClient (Bit Slow while
connecting)
2. RDA or Merge Replication of SQL CE (RDA is Good to start with, merge

replication is little difficult to setup but easy to implement)
3. Web Services (Comparitively Slow)

RDA and Web Services seems to be similar when the size of data is
minimal. If you try to synchronize a large volume of data then there
you will find RDA better than Web Services as for as the data
transfer speed is concerned.

XML Web Services Pros:
1. Cross platform availability
2. Secured using SSL and HTTP Authentication

XML Web Services Cons:
1. Slow Performance (slowest of all)
2. No in-built support for synchronizing data (we will have to
implement)
3. Data transfers as XML so not as efficient as binary formats used
by RDA or Merge Replication
4. SQL Server CE takes up memory if stored in CE tables

SQL Server CE RDA Pros:
1. Simple to setup
2. Rich functionality provided by SQL Server CE

SQL Server CE RDA Cons:
1. SQL Server CE takes up memory
2. No merging functionality built-in (we will have to implement it)
You can choose from these and get the data to SQL CE and your
application will work stand alone.

If your desktop database is not SQL Server, you may choose XML Web
Services as the sync option.

If you are not going to use any database and you can simply sync XML
file or CSV file using Active Sync.

In all the condition you can use SQL Server CE as your PPC database.

> Can this be done somehow
>using GSM?

GSM is telephony, for sync to work you need a modem and a dial up
connection to establish internet connection so that from field workers
can sync to through the internet.
Other wise GPRS connection can also do the work. Web Services is a
reliable way to do sync when using GPRS.

>The sync will be somewhat complex in the rules that it
>will require...any suggestions anyone

Can you eloborate this more. I understood like the records can be
changed at both end (PPC and desktop), this can be handled with Merge
Replication between SQL Server and SQL Server CE.


Hope this helps,
Regards,
Arun.
www.innasite.com

.

Relevant Pages

  • Re: How to Synch up a device and desktop
    ... desktop database and PPC database. ... RDA or Merge Replication of SQL CE (RDA is Good to start with, ... SQL Server CE takes up memory if stored in CE tables ... Services as the sync option. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Reality check
    ... the impression that SQL Server was going to be more difficult. ... > Keeping two database in sync with different schema is tricky, ... > database pushing to the other smooth before going two-way. ... > use a trigger to update the updated column with every update. ...
    (microsoft.public.sqlserver.programming)
  • Re: Alternatives to SQL Server Mobile?
    ... Intellisync offers robust database sync between SQL Mobile, ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: Replication problem
    ... any data or not) before you tried to sync? ... Are your database server and your IIs machine the same machine? ... I have the Microsoft SQL Desktop Engine installed on the ... > ever working with an SQL server. ...
    (microsoft.public.sqlserver.ce)
  • Deployment & Local Debugging
    ... environment for web services and a database. ... I have a remote server ... Other alternatives are to allow the sql server to be ... accessed remotely or to first deploy the web services to the web. ...
    (microsoft.public.dotnet.framework.webservices)
Loading