Re: Pocket Access v SQL CE
From: RB (robert_at_brokerforce.com.NoSpam)
Date: 10/19/04
- Next message: SBunger: "Problems removing old product on device during install"
- Previous message: Chico: "Mobile Forms on the Fly..."
- In reply to: Darren Shaffer: "Re: Pocket Access v SQL CE"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 12:09:31 -0600
Darren:
Thank you for your answer. This is what I suspected and will probably make
a call to my pocket app that will load the csv into the SQL CE db on the
device.
The tables I need to access in these formats are relatively static and
wouldn't need to be repopulated very frequently. Do you know what I could
expect as the speed difference for searching a 50K record XML table versus a
SQL CE db table?
Regards,
R B
"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:uRMFTtMtEHA.3200@TK2MSFTNGP14.phx.gbl...
> Robert,
>
> If you just need to periodically create SQL CE database files
> to provide relatively static lookup data to your mobile app,
> you can export your Access DB to CSV, place the CSV file on
> device (manually or as content in your CF project), and then create and
> populate the SQL CE db on device when your CF app starts. Note,
> you really only have to do this on one device since you can take
> the resulting SQL CE dbms (SDF file) and include it as content
> in your CF project's CAB file. With Yukon, you will be able to
> do this easily with DTS.
>
> If you're thinking of doing some sort of synchronization between
> SQL CE and MS Access, you'll need to use XML Web Services
> to do this. There is no built in synchronization between Access and
> SQL CE.
>
> -Darren
>
> "RB" <robert@nospam.BrokerForce.com> wrote in message
> news:ej6fqwLtEHA.2564@TK2MSFTNGP10.phx.gbl...
>> I'm using Access 2000. If I am not using SQL server, how can I populate
>> and use SQL CE on the device instead of a CDB file?
>>
>> I have too many records and the CDB is just too slow.
>>
>> What is an *.sdf file on a hand held?
>>
>> Would XML be a better answer? I typically have 20,000 records plus in my
>> products table.
>>
>> Thanks in advance,
>>
>> R B
>>
>
>
- Next message: SBunger: "Problems removing old product on device during install"
- Previous message: Chico: "Mobile Forms on the Fly..."
- In reply to: Darren Shaffer: "Re: Pocket Access v SQL CE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
