Database for a Pocket PC - Desktop syncing application

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?

Peter
Sat Feb 23 08:48:49 CST 2008

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" <satish_appasani@hotmail.com> wrote in message
news:uixweeidIHA.544@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
Sat Feb 23 11:55:26 CST 2008

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" <feedback@nospam-inthehand.com> wrote in message
news:508C6628-7F7D-4238-BB0A-F12FABFEA28E@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" <satish_appasani@hotmail.com> wrote in message
> news:uixweeidIHA.544@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
Sat Feb 23 13:31:47 CST 2008

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" <satish_appasani@hotmail.com> wrote in message
news:uixweeidIHA.544@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
Mon Feb 25 02:05:55 CST 2008

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=A0am, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> 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" <satish_appas...@hotmail.com> wrote in message
>
> news:uixweeidIHA.544@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 us=
e
> > 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 C=
E
> > and Access on the desktop. Or build a custom binary data file.
>
> > Any suggestions please?- Hide quoted text -
>
> - Show quoted text -

Satish
Thu Mar 06 08:34:29 CST 2008

Hi



Great suggestion. I cannot use SQL Compact 3.5 as all my development systems
are still using VS 2005. I don't have VS 2008. So planning to use SQL
Compact 3.1.



What are the major differences between 3.1 and 3.5?



Thank you

Satish

"Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message
news:936DC920-8547-48DA-BDDF-E44A25E048DC@microsoft.com...
> 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" <satish_appasani@hotmail.com> wrote in message
> news:uixweeidIHA.544@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
Thu Mar 06 09:48:51 CST 2008

Satish,

You can search online for "whats new SQL Compact 3.5" for all the details.
Here are some highlights:

More encryption options
New data type - rowversion
Supports Top() in queries
Support for Sync Services for ADO.NET
More tool support in VS 2008

Why not upgrade to VS 2008?


--
Ginny Caughey
Device Application Development MVP

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



"Satish Appasani" <satish_appasani@hotmail.com> wrote in message
news:uBmxzc5fIHA.4476@TK2MSFTNGP06.phx.gbl...
> Hi
>
>
>
> Great suggestion. I cannot use SQL Compact 3.5 as all my development
> systems are still using VS 2005. I don't have VS 2008. So planning to use
> SQL Compact 3.1.
>
>
>
> What are the major differences between 3.1 and 3.5?
>
>
>
> Thank you
>
> Satish
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
> message news:936DC920-8547-48DA-BDDF-E44A25E048DC@microsoft.com...
>> 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" <satish_appasani@hotmail.com> wrote in message
>> news:uixweeidIHA.544@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?
>>>
>>
>
>

Satish
Thu Mar 06 09:59:02 CST 2008

I don't have my own copy of Visual Studio. I use my work systems and our dev
environment is not yet upgraded to VS 2008. Buying Visual Studio is
moderately expensive in India.
"Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message
news:7FD237AC-F201-4709-A7F6-FFB63C54B245@microsoft.com...
> Satish,
>
> You can search online for "whats new SQL Compact 3.5" for all the details.
> Here are some highlights:
>
> More encryption options
> New data type - rowversion
> Supports Top() in queries
> Support for Sync Services for ADO.NET
> More tool support in VS 2008
>
> Why not upgrade to VS 2008?
>
>
> --
> Ginny Caughey
> Device Application Development MVP
>
> www.wasteworks.com
> Scalehouse and Billing Software for Waste Management
>
>
>
> "Satish Appasani" <satish_appasani@hotmail.com> wrote in message
> news:uBmxzc5fIHA.4476@TK2MSFTNGP06.phx.gbl...
>> Hi
>>
>>
>>
>> Great suggestion. I cannot use SQL Compact 3.5 as all my development
>> systems are still using VS 2005. I don't have VS 2008. So planning to use
>> SQL Compact 3.1.
>>
>>
>>
>> What are the major differences between 3.1 and 3.5?
>>
>>
>>
>> Thank you
>>
>> Satish
>>
>> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
>> message news:936DC920-8547-48DA-BDDF-E44A25E048DC@microsoft.com...
>>> 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" <satish_appasani@hotmail.com> wrote in message
>>> news:uixweeidIHA.544@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
Thu Mar 06 10:15:21 CST 2008

Satish,

Understood. Maybe your team will upgrade before long. They can still
continue to target .NET 2.0 from VS 2008.

--
Ginny Caughey
Device Application Development MVP

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



"Satish Appasani" <satish_appasani@hotmail.com> wrote in message
news:u6h3CM6fIHA.3940@TK2MSFTNGP05.phx.gbl...
>I don't have my own copy of Visual Studio. I use my work systems and our
>dev environment is not yet upgraded to VS 2008. Buying Visual Studio is
>moderately expensive in India.
> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
> message news:7FD237AC-F201-4709-A7F6-FFB63C54B245@microsoft.com...
>> Satish,
>>
>> You can search online for "whats new SQL Compact 3.5" for all the
>> details. Here are some highlights:
>>
>> More encryption options
>> New data type - rowversion
>> Supports Top() in queries
>> Support for Sync Services for ADO.NET
>> More tool support in VS 2008
>>
>> Why not upgrade to VS 2008?
>>
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>> www.wasteworks.com
>> Scalehouse and Billing Software for Waste Management
>>
>>
>>
>> "Satish Appasani" <satish_appasani@hotmail.com> wrote in message
>> news:uBmxzc5fIHA.4476@TK2MSFTNGP06.phx.gbl...
>>> Hi
>>>
>>>
>>>
>>> Great suggestion. I cannot use SQL Compact 3.5 as all my development
>>> systems are still using VS 2005. I don't have VS 2008. So planning to
>>> use SQL Compact 3.1.
>>>
>>>
>>>
>>> What are the major differences between 3.1 and 3.5?
>>>
>>>
>>>
>>> Thank you
>>>
>>> Satish
>>>
>>> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
>>> message news:936DC920-8547-48DA-BDDF-E44A25E048DC@microsoft.com...
>>>> 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" <satish_appasani@hotmail.com> wrote in message
>>>> news:uixweeidIHA.544@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?
>>>>>
>>>>
>>>
>>>
>>
>
>