Server databases typically reside in a well-secured zone, with limited access to applications residing in other network topologies. As a result, data in the database is secured because of network location and access rights. In addition, database backup or sophisticated data management exists to protect against data loss.
Databases existing on client systems have different levels of protection. Physical device security is the first barrier in preventing unauthorized access to databases. This includes locking up or securing the physical device as well as providing secure passwords to protect against others illicitly using the device to access data. An additional way to protect the data in the database is to use the encryption technologies provided by the databases. The entire database, or specific tables, can be encrypted using a key (password) that must be provided by the user. This protects against someone being able to open the database if they were to obtain the physical media storing the database (such as a CD for read-only databases, memory keys, Compact Flash cards, and so on).
To protect against data loss, especially for local databases or local synchronized databases, you should put a backup or synchronization strategy in place to ensure that data is synchronized on an appropriate schedule. Incidentally, this also reduces the chances of data on the device becoming out of date.
Parent topic: Deployment and synchronization: XPD621