Pervasive.SQL V8 Product Information
Important Note: Pervasive Software has discontinued selling the Pervasive.SQL V8 database engine product as of July 1, 2006, including both new server licenses and user count increases. The product becomes completely unsupported by Pervasive Software after December 31, 2006.
Goldstar Software will continue to provide services for and to support this product release for as long as we can, and will sell licenses only while we still have them in stock. Of course, we do urge all Pervasive.SQL V8 users to begin migration plans to Actian PSQL v12 if possible.
Pervasive.SQL V8.7 is the last release in the Pervasive.SQL V8 product line from Pervasive Software. The original PSQLV8 product started shipping in December 2002, and this release from August 2005 will be the last update available.
Pervasive.SQL V8 builds on the success of Pervasive.SQL 2000i by providing some great new features. Here's a short list:
What are the downsides to upgrading? Well, there are a few minor issues...
- Improved Btrieve Performance:
The combination of improved server-side code and a new workstation-side caching engine gives new life to older
Btrieve applications! Most applications will seem some performance gains. However, applications which normally
experience some performance drag from client/server engines will see a HUGE performance gain with the new caching
engine! I've actually witnessed 4x performance gains in one customer application, but Pervasive has estimated 20%,
which seems about right.
- Improved SQL Performance:
Pervasive Software developers reworked portions of the SQL optimizer to improve performance for many types of queries.
The net result should be better performance overall for most users!
- New SQL Syntax: They
even added some neat new features missing from Pervasive.SQL 2000, such as the TOP and ROWCOUNT features, TIME
ZONE support, DECIMALSEPARATORCOMMA support for European numeric formats, SQL_TIMEOUT support, and the ability
to put DDL in stored procedures. This last one alone is worth the upgrade for some developers!
- No More Workstation Engine:
The death of an engine is a feature? In this case, YES! The old single-user WSE is now history, only the WorkGroup
Engine (WGE) is available. This allows for cheaper pricing than the Pervasive.SQL 2000i WGE and should result in
cost savings for everyone!
- New File Format: An
optional change, the new 8.x file format can also provide more performance gains. However, I'd personally wait
until I get some tools to deal with them, should they ever get corrupted.
- Simpler Configuration:
Even more of the configuration settings are disappearing as the engine self-tunes the memory requirements. This
just makes it easier for end-users to do the initial setup!
- Debug Requesters: While
not exactly new, for the first time, Pervasive plans to ship the Debug Requesters with the engine. Should make
for some interesting times when people start to "play".
- Simpler Licensing:
Instead of the 33-byte UCMGR.KEY file, licensing is now accomplished by 24-character ASCII codes, a la Microsoft.
The jury is still out on which is easier, but personally I think applying the file took far less time than typing
those lengthy codes...
- Price: What, you expected
it to be free? This is a paid upgrade, but one which should be well worth the money, IMHO.
- Lack of Windows 95 Support:
You knew it would come -- Microsoft already killed this OS -- and now Pervasive stops supporting it as well. It
might work, but they won't help you if it doesn't.
- Increased Prices on Unlimited Engines:
Whereas previous engines became "Unlimited" at 200 licensed users, the new P8 engine has license counts
at 250, 500, and Unlimited users, with higher prices for each. Users with less than 250 users won't notice the
change, but sites with over 250 (and especially over 500) users will definitely notice the price increases.
Unlike with the upgrade from Pervasive.SQL 7 to Pervasive.SQL 2000i,
this upgrade is more evolutionary in nature. In fact, we cannot think of ANY reason to date why a user would not be able to immediately upgrade
to Pervasive.SQL 8. While this will probably scuttle the PSQL2000i sales, the good news is that end users and developers won't have any reasons
to hold back and NOT upgrade, so everybody wins!
Pricing can be found on our Pervasive.SQL V8 price list, or you can BUY IT NOW from our on-line store.
If you want to try it out before you buy it (and who doesn't?), or if you just need to replace a broken or missing installation CDROM, you can get an evaluation download to get started with the product for
30 days. Of course, we also recommend making sure that you meet the
Pervasive.SQL V8 Pre-Requisites list on your network before attempting this.
[Expand Entire Page... ]
[Collapse Entire Page... ]
[+] Pervasive.SQL V8.71 (Service Pack 3 Updates)...
[+] Pervasive.SQL V8.70 (Service Pack 3)...
[+] Pervasive.SQL V8.60 (Service Pack 2)...
[+] Pervasive.SQL V8.50 Security Release...
On 10/27/2003, Pervasive Software released the long-awaited Security Feature Pack for Pervasive.SQL V8. Also known as Pervasive.SQL V8.5 Security, this feature
pack provides some wonderful new features designed to increase security, including the following:
Download the Pervasive.SQL V8.50 Security Patch or Install Media. (Login Required)
- New Security Models for Btrieve Applications: Known as Advanced Security, this feature enables Btrieve developers and users to
enable a much more advanced security model, eliminating the dependence on file access rights.
- Across-The-Wire Encryption: The database client can now encrypt network traffic to increase the level oif security and keep
critical data from prying eyes.
- Database-wide SQL Permissions: The engine can now easily grant access to all SQL tables at the same time.
- Improved Documentation: A new documentation layout makes ity easier to find what you are looking for!
[+] Pervasive.SQL V8.10 (Service Pack 1)...
[+] Pervasive.SQL V8.00 (FCS)...
Released in September 2007, the FCS (First Customer Ship) product build offers a lot of new features to users of older PSQL versions.
This release includes the features listed at the top of this page, and is a paid upgrade to previous versions (PSQL2000i and earlier).
If you are running the V8.00 code (FCS), then we strongly recommend upgrading to the latest patches, if possible.
Download the Pervasive.SQL V8.00 Install Media. (Login Required)
[+] Frequently Asked Questions About Patching Pervasive.SQL V8...
Q: Is PSQLV8 still supported?
A: Pervasive Software stopped supporting this engine on July 1, 2006. Goldstar Software continues to support it for our customers.
Q: Which version should I get, Server or Workgroup?
A: Get the same as the license you have purchased. This is documented on your original invoice. If you do not have your original invoice, start the Pervasive License Administrator tool on the server (Start/Programs/Pervasive/Other Utilities/License Administrator) and see if it states "Workgroup" or "Server" therein. The Workgroup Engine upgrade must be applied to EVERY computer in the WGE environment. In a Server Engine environment, the server engine update gets installed on the server, and the client update gets applied to each workstation.
Q: How long will it take to download the update?
A: This depends on your Internet link speed.
Q: I have dial-up or no Internet access. Now what?
A: As a convenience, Goldstar Software can ship PSQLV8.7 patch CDROM's for a fixed cost of $30, shipping included. Contact us to arrange a shipment, and be sure to specify Workgroup or Server.
Q: Do I have to download the update on each machine?
A: The update must be applied to each machine, as noted above. You can download the update ONE time, save the file to the server, and then use that copy of the download to update each computer. The the Server Engine, if you patch the server first, you can simply re-run the Client Installer from the server's C:\PVSW\CLIENTS folder.
Q: I don't know what any of this means. What can I do?
A: Goldstar Software has a remote installation service with which we can provide the installation and update over the Internet, by a Pervasive-certified expert in their database technology. The cost is $250 per server and $100 per workstation. This may need to be scheduled in advance, as your application will be unavailable during the process.
[Expand Entire Page... ]
[Collapse Entire Page... ]
If you have additional questions about the product, please contact us!