I have a PervasiveSQL database running on a Linux platform and the front end app is written in VB.Net 2003. I now want to create an addon app on a Pocket PC for stock taking.

I intend to dump the stock details out from PervasiveSQL into a CSV file. This will be copied onto the Pocket PC device and the app on the device will import the CSV file into a SQL CE database.

All that is fine but my biggest concern is that the procedure takes up double the amount of disk space i.e. I will end up with the CSV and SDF files on the device.

Is there anyway of building the SDF on the PC or can anybody suggest a better method.

Thanks