I have developed a smart device application using SQL Mobile for data
storage. The data is modified from the application and sync with HO database.
The 2nd Phase of the application consist of customer enquiry from Pocket PC.
The data will be fetched from web service and stored on the device. The data
should be available to the PPC user in offline mode. The data won't be
modified on PPC and would be in readonly mode.

Creating new tables in SQL Mobile database for datastorage and retrieval is
the one of the option.
Other option is to store the data in XML files and retrieve the data when
queried by the user.
I am not sure of the pro's & con's in using the 2nd option....can anyone help

Re: Storing data in XML files on Pocket PC by Chris

Chris
Mon Nov 27 14:21:27 CST 2006

"Nilesh" <Nilesh@discussions.microsoft.com> wrote in message
news:4E4112D6-37DC-44E0-859D-BD52A83C695F@microsoft.com...
> The data will be fetched from web service and stored on the device. The
> data
> should be available to the PPC user in offline mode. The data won't be
> modified on PPC and would be in readonly mode.
>
> Creating new tables in SQL Mobile database for datastorage and retrieval
> is
> the one of the option.
> Other option is to store the data in XML files and retrieve the data when
> queried by the user.
> I am not sure of the pro's & con's in using the 2nd option....can anyone
> help
>

It mainly depends on your own application/device requirements. The only
drawback I can think of with using XML is space and that can be resolved
with compression. I've used XML in the past only because I wanted to
preserve the original content as it came from the web service.