They require all users to be out of the system, at which point the files containing the data can be backed up using standard network backup procedures. In order to have tight database security, security must be provided at the level of the network, servers, databases, tables, and SQL statements. SQL Server and Microsoft Jet both offer a high degree of security at each of the data levels, offering logon IDs and passwords, user permissions, and encryption. SQL Server also allows integration of its security with network security. While the FoxPro engine has no native security, Win32 encryption API and third-party solutions are available to allow developers to customize security to their needs.
Replication allows data to be copied automatically from one database to another.
Typical uses include distributed processing, load balancing, and dynamic backup. Each of the database engines provides support for replication, though their goals are somewhat different. Replication in Visual FoxPro is designed for performance and flexibility. Updates to each table are restricted to a single site, to enforce guaranteed logical consistency in the database. The Microsoft Jet engine supports the multimaster model of replication with other Microsoft Jet databases.