Database for a Pocket PC - Desktop syncing application

Satish Appasani · Joined: 23 Feb 2008 Posts: 1

I am planning to build a utiltiy for Pocket PC and sync it's data with it's
counterpart on the desktop. Something in the lines of Illium eWallet.

What is the best database to use for this type of applications? I can use
SQL Server mobile on PDA but the SQL Server on the desktop will be overkill
for my targer audience. Access will be the right choice for desktop. I don't
see any solid solution for Access on Pocket PC.

An idea is to build a sync application to sync data between SQL Server CE
and Access on the desktop. Or build a custom binary data file.

Any suggestions please?

Archived from group: microsoft>public>pocketpc>developer

Peter Foot · Joined: 01 Sep 2007 Posts: 56

Microsoft has a product to do exactly this:-
http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en

Peter

--
Peter Foot
Microsoft Device Application Development MVP
www.peterfoot.net | www.inthehand.com
In The Hand Ltd - .NET Solutions for Mobility

"Satish Appasani" wrote in message @TK2MSFTNGP05.phx.gbl...
>I am planning to build a utiltiy for Pocket PC and sync it's data with it's
>counterpart on the desktop. Something in the lines of Illium eWallet.
>
> What is the best database to use for this type of applications? I can use
> SQL Server mobile on PDA but the SQL Server on the desktop will be
> overkill for my targer audience. Access will be the right choice for
> desktop. I don't see any solid solution for Access on Pocket PC.
>
> An idea is to build a sync application to sync data between SQL Server CE
> and Access on the desktop. Or build a custom binary data file.
>
> Any suggestions please?
>

Christian Resma Helle · Joined: 15 Aug 2007 Posts: 6

If you're using Windows Vista then Access Database Synchronizer will be a
complete waste of your time...

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com

"Peter Foot" wrote in message @microsoft.com...
> Microsoft has a product to do exactly this:-
> http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en
>
> Peter
>
> --
> Peter Foot
> Microsoft Device Application Development MVP
> www.peterfoot.net | www.inthehand.com
> In The Hand Ltd - .NET Solutions for Mobility
>
> "Satish Appasani" wrote in message
> @TK2MSFTNGP05.phx.gbl...
>>I am planning to build a utiltiy for Pocket PC and sync it's data with
>>it's counterpart on the desktop. Something in the lines of Illium eWallet.
>>
>> What is the best database to use for this type of applications? I can use
>> SQL Server mobile on PDA but the SQL Server on the desktop will be
>> overkill for my targer audience. Access will be the right choice for
>> desktop. I don't see any solid solution for Access on Pocket PC.
>>
>> An idea is to build a sync application to sync data between SQL Server CE
>> and Access on the desktop. Or build a custom binary data file.
>>
>> Any suggestions please?
>>
>

Ginny Caughey [MVP] · Joined: 15 Aug 2007 Posts: 425

Staish,

Why not just use SQL Compact on both the desktop and the device?

--
Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management

"Satish Appasani" wrote in message @TK2MSFTNGP05.phx.gbl...
>I am planning to build a utiltiy for Pocket PC and sync it's data with it's
>counterpart on the desktop. Something in the lines of Illium eWallet.
>
> What is the best database to use for this type of applications? I can use
> SQL Server mobile on PDA but the SQL Server on the desktop will be
> overkill for my targer audience. Access will be the right choice for
> desktop. I don't see any solid solution for Access on Pocket PC.
>
> An idea is to build a sync application to sync data between SQL Server CE
> and Access on the desktop. Or build a custom binary data file.
>
> Any suggestions please?
>

Nash · Joined: 24 Oct 2007 Posts: 16

Dear Sathish,
If you are planning to use .Net CF 3.5 then you can use SQL Compact
Edition and you can use Sync Services to sync the data.

On Feb 24, 12:31 am, "Ginny Caughey [MVP]"
wrote:
> Staish,
>
> Why not just use SQL Compact on both the desktop and the device?
>
> --
> Ginny Caughey
> Device Application Development MVP
>
> www.wasteworks.com
> Scalehouse and Billing Software for Waste Management
>
> "Satish Appasani" wrote in message
>
> @TK2MSFTNGP05.phx.gbl...
>
>
>
> >I am planning to build a utiltiy for Pocket PC and sync it's data with it's
> >counterpart on the desktop. Something in the lines of Illium eWallet.
>
> > What is the best database to use for this type of applications? I can use
> > SQL Server mobile on PDA but the SQL Server on the desktop will be
> > overkill for my targer audience. Access will be the right choice for
> > desktop. I don't see any solid solution for Access on Pocket PC.
>
> > An idea is to build a sync application to sync data between SQL Server CE
> > and Access on the desktop. Or build a custom binary data file.
>
> > Any suggestions please?- Hide quoted text -
>
> - Show quoted text -

Push SQL Database From Desktop To SQLCE Dear All, I am new in the pocket pc developing. I am using VB6, and SQL currently. I would like to make a program to push SQL database to the pocket pc SQL CE, so do anyone can tell me how to do it??? Previously i success in using RDA to push and pull t

desktop application gets info stored in device I would like to write a program running in desktop which can get SMS info stored in device.How to do it? Any examples? thank in advance.

Synchronising data between PDA database and system database Hi All, Im new to developing PDA have a SQl Mobile edition database running in my PDA and a sql server 2005 database on my Web i need to synch the contents between my mobile database and server database. Is there any app

how to run an application in pocket pc always Hello, I am looking for help on how to develop an application for pocket pc phone that will always run when the phone is switched on. the application should be minimized to an icon on the home screen and tapping on it will bring up the setting screen. Als

can not debug pocket pc application Hello everyone, I am using Visual Studio 2005 to debug a Pocket PC 2003 application on Poacket PC 2003 SE Emulator (I am using ARMV4 When using F5 to execute the application, the break points I have set before debug (F5) becomes, the inform