I am developing an application for Pocket PC which is a sort of order
entry. On the pocket pc you enter which items has been taken out from
inventory and which is later processed in the main (stationary) windows
application.
The main windows application don't use SQL server (it might for some
clients though). I really don't need any replication of the orders
entered on the Pocket PC with the orders in the Windows application,
only need to read the data entered on the PocketPC and process the data
in the windows application.
There are also some data that need to be transfered from the main
database to the Pocket PC which is used for lookup (products table etc)
which are not updated in the PPC application.
I also woulk like to keep the "stationary" side as simpel as possible
(ie not using Web services and/or a SQL server database on the
stationary side).
On my PPC application I use a SQL Mobile dtaabase to store my data.
What is the easist solution for exhanging data? One idea I have is to
simple have an option in my PPC application for transfer data which
will:
1) Export orders entered on PPC to an ASCII file (CSV, XML whatever)
2) Delete orders after export file has been created/transferred
3) Import lookup tables to PPC database
Any better solution?
I don't have much experience of PPC devices (but have been workign with
other handhelds like the PSion Workabout pre-Windows CE) so I am not
sure which options there are. Have only been using the emulator so far.