Understanding the DBMS Products
Pervasive PSQL is available in different versions. The major differences between the versions are price, multi-user features, and the licensing model used.
•
Pervasive PSQL Workgroup is the least expensive, but it provides support only for small workgroup environments.
•
Pervasive PSQL Server is designed for maximum scalability in high-volume, mission critical database applications where there is a dedicated database server. The Server engine quickly becomes most economical as you increase the number of users.
•
Pervasive PSQL Vx Server engine is designed for use in highly virtualized environments.
The database engine in all of the versions is fully compatible with any Pervasive PSQL database, and was designed with a common architecture. To upgrade from Workgroup to Server typically requires no changes to your application or to your database. Simply install the new version and you are ready to go. Because Pervasive PSQL Vx Server uses a different license model, it requires a full installation. You cannot upgrade Pervasive PSQL Server or Workgroup to Pervasive PSQL Vx Server.
Pervasive PSQL Workgroup
Pervasive PSQL Workgroup offers a peer-to-peer network setup designed for stand-alone single-user installations up to small workgroups. The Workgroup engine is the only engine that offers multi-user access to Pervasive PSQL data located on a computer where no database engine is installed.
A major difference between Workgroup and Server is the Gateway feature of Workgroup. When there is no database engine running on the computer where the data is located, normally the first database engine to connect to that data handles all requests from other engines to access that data. This feature can be configured so that the same Workgroup engine always services that data, or the Gateway designation can be allowed to “float” based on which Workgroup engine connects to the data first during any given work day.
The Workgroup product uses the user count licensing model. See License Models.
Pervasive PSQL Server
Pervasive PSQL Server offers a full client/server architecture providing excellent performance and scalability for up to thousands of concurrent users. The Server engine can be monitored and configured remotely.
The Server engine must be located on the same computer as the data files it is intended to access.
Pervasive PSQL Server uses the user count licensing model. See License Models.
Pervasive PSQL Vx Server
Pervasive PSQL Vx Server is designed to support highly virtualized environments. For instance, Vx Server includes support for Cloud computing (private, community, and hybrid), as well as for full virtualization, partial virtualization, and paravirtualization. Pervasive PSQL Vx Server has no restrictions on hosting, connection pooling, Internet or intranet use. No additional license is required for use with hypervisor features such as live migration, failover, fault tolerance (FT), high availability (HA), and disaster recovery. Pervasive PSQL Vx Server remains authorized and fully functional provided that the MAC addresses and hostname remain consistent and Internet connectivity is maintained.
Pervasive PSQL Vx Server uses the capacity-based licensing model. See License Models.
Because Pervasive PSQL Vx Server is built on technology used for Pervasive PSQL Server, it shares much of the database functionality and documentation provided for Pervasive PSQL Server. Throughout the Pervasive PSQL documentation, all topics pertaining to Pervasive PSQL Server also apply to Pervasive PSQL Vx Server unless differences are explicitly called out. For convenience of reference, the Pervasive PSQL Vx Product Guide contains content specific to Pervasive PSQL Vx Server.
Crystal Reports for Pervasive PSQL
Crystal Reports is an optional product that provides rich capabilities for creating and formatting reports based on Pervasive PSQL databases. Reports can be customized in thousands of ways and published as HTML, Microsoft Word document, Microsoft Excel document, or other formats.
For more information about Crystal Reports, contact your sales representative or visit the Pervasive web site at http://www.pervasivedb.com.