Pocket DB
Database System for Windows Mobile Pocket PCs.


INTRODUCTION
How would you like to have your desktop Access or SQL Server databases with you on your Pocket PC or smart phone anywhere, any time?

Pocket DB is a database program designed for the new Windows Mobile 5.0 Pocket PCs, the Palm Treo 700W in specific, and all WM5 devices with a square screen in general. Whether you want to have a simple AddressBook table with only dozens of addresses, a movie database with several hundred records, or multiple tables with tens of thousands of records for things such as financial transactions, Pocket DB can handle these with ease.

The program uses the latest SQL Server Mobile database engine. In order to use Pocket DB, you must already have the database files .sdf reside in your Pocket PC. The .sdf files can be exported or synchronized from Microsoft Access or SQL Server database to your device from your desktop PC using 3rd party tools such as Data Port Wizard, Data Port Command, or Data Port Sync from Primeworks (www.primeworks-mobile.com). 

Pocket DB was designed from the ground up to handle tables with large number of records. It only retrieves and displays the number of records that the small Pocket PC's screen can display. This significantly helps in record navigation tasks and makes the retrieval of any record a snap. You can retrieve records in seconds even on tables with tens of thousands of records on a slow 312 MHz Palm Treo 700W. 

Using Pocket DB, you can add, edit, remove records on your Pocket PC.  Data can be accessed under both "Grid View" and "Record View" modes.

The program offers a filter facility so you build custom filters for fast access to your data.

Advanced users can issue SQL statements directly to the SQL Server Mobile engine to have total control over the manipulation of their data.

Chris Doan
San Diego, California
January 2007

chris.doan@cdsoftwaresolutions.com
www.cdsoftwaresolutions.com


FEATURES
* Flexibility: Both grid view and record view are available. Use grid view for quick glance at records that meet a certain crieria, then record view to drill down to a specific record's details. 
* Lookup Fields: Enter data much faster with lookup for field input. You can link a foreign field from the primary table to a primary field from another table. 
* Filtering: Data can be filtered for precise access and saved with different filter files. 
* Easy/fast record navigation: Data is presented one screen at a time. Navigation buttons are provided for snappy records browsing. 
* Industry-standard mobile database engine: SQL Server 2005 Compact Edition database engine. 
* Expandability: SQF files can reside on SD card to accommodate large databases. 


SYNCHRONIZE WITH DESKTOP DATABASES
Pocket DB does not handle data exhange or synchronization with Microsoft Access or SQL Server databases. You must use other tools such as Data Port Sync, Data Port Wizard, and Data Port Command to handle the data interchange between your device and desktop database. I recommend  tools marketed by Primeworks (www.primeworks-mobile.com). 


SOFTWARE REQUIREMENTS
Desktop PC:
* All version of Windows

Windows Mobile Pocket PC:
* Microsoft .NET Compact Framework 2.0.

Guarantuee to work on the Palm Treo 700W.
Should work on all other WM5 devices with a square screen.


INSTALLATION INSTRUCTION
Copy the file "Pocket DB.CAB" to your device and run it from there.


TRIAL PERIOD
The trial version of Pocket DB is fully functional for 31 days. The full version can be purchased from 
www.cdsoftwaresolutions.com/pocketdb.html.
