PDA SQL Sync Architecture VS2005

Hi,

I am looking to develop a PocketPC App using VB.Net or C# and a mobile SQL
database. I will then need to Sync mobile changes back to main server. I'll
then try to go one step further and push changes from server back to PDA.


Before diving head first I am trying to get an idea of overall best practice
for architecture/technology to use, specifically for synchronisation between
PDAs and a main SQL server. I will eventually want to be able to synchronise
whilst docked and while connected GPRS (or other live connection).

I had a quick read on ActiveSync which at every turn looked like a C++
nightmare of 'ActiveSync Providers' for my own objects/tables.

Can anyone supply a basic mud-map of options here, suggest best practice or
point to an idiot's guide to synchrnisation?

TIA

Simon

Andrew
Fri Feb 03 10:05:52 CST 2006

Sounds like you want to reinvent the wheel here. I manage a product which
fits your description perfectly. You concentrate on building your client and
server apps and we provide the sync. You have APIs at both ends to plug into
it easily.

Perhaps you can contact me offlist and we can discuss.

Andrew


"Gramps" <simon_hooker@NO.SPAMiprimus.com.au> wrote in message
news:%23HIJTpIKGHA.2088@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am looking to develop a PocketPC App using VB.Net or C# and a mobile SQL
> database. I will then need to Sync mobile changes back to main server.
> I'll then try to go one step further and push changes from server back to
> PDA.
>
>
> Before diving head first I am trying to get an idea of overall best
> practice for architecture/technology to use, specifically for
> synchronisation between PDAs and a main SQL server. I will eventually want
> to be able to synchronise whilst docked and while connected GPRS (or other
> live connection).
>
> I had a quick read on ActiveSync which at every turn looked like a C++
> nightmare of 'ActiveSync Providers' for my own objects/tables.
>
> Can anyone supply a basic mud-map of options here, suggest best practice
> or point to an idiot's guide to synchrnisation?
>
> TIA
>
> Simon
>
>
>

Rick
Tue Feb 07 15:06:33 CST 2006

You can also visit http://www.primeworks.pt/ . They have products that
directly read the device mobile sql database. I use their products to
develop my own synchronization process. It is quite fast and works very
well. And, in my case, I can sync with any PC database, Access, Sql Server,
whatever, as my customers have both.

Rick Lederman
Soaring Software Solutions, Inc.
www.soaringsoftware.com
rick@soaringsoftware.com


"Gramps" <simon_hooker@NO.SPAMiprimus.com.au> wrote in message
news:%23HIJTpIKGHA.2088@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I am looking to develop a PocketPC App using VB.Net or C# and a mobile SQL
> database. I will then need to Sync mobile changes back to main server.
> I'll then try to go one step further and push changes from server back to
> PDA.
>
>
> Before diving head first I am trying to get an idea of overall best
> practice for architecture/technology to use, specifically for
> synchronisation between PDAs and a main SQL server. I will eventually want
> to be able to synchronise whilst docked and while connected GPRS (or other
> live connection).
>
> I had a quick read on ActiveSync which at every turn looked like a C++
> nightmare of 'ActiveSync Providers' for my own objects/tables.
>
> Can anyone supply a basic mud-map of options here, suggest best practice
> or point to an idiot's guide to synchrnisation?
>
> TIA
>
> Simon
>
>
>