Before You Begin
Show this topic in Library frames
Before upgrading to Pervasive.SQL 9 SP1 (9.1), begin by reviewing the following documents for important information:
- Chapter 2, Preparing to Install Pervasive.SQL - This chapter provides important information including system requirements and platform specific notes that are relevant to your operation.
- README file - This file is located on the distribution media and contains late-breaking product news that could not be included in the product documentation.
Considerations
Once you have reviewed the latest product information, review this list of considerations to complete your upgrade installation preparation.
- Pervasive.SQL Applications - Be aware of what applications you have currently using previous versions of Btrieve or Pervasive.SQL in your environment. Don't forget to include both client and server-based applications, such as ArcServe.
- Vendor-Specific Information - Be sure and check with your application vendors for any specific information regarding their product with Pervasive.SQL.
- TCP/IP Protocol - DOS applications require different requesters, preferably BTRBOX95, BTRDRVR, or BREQTCP.
- New Features and File Rebuilding - In order to make use of all the new version features, you must rebuild your data files so that they use the newest version file format. Pervasive.SQL Advanced Operations Guide includes a chapter that details using the Rebuild Utility to rebuild your data files, if you would like to take advantage of newer features.
- Back Up Data Files - Make sure you have a current backup of all your data files prior to beginning upgrade installation
Platform Notes for Windows
This section contains installation information specific to Windows 32-bit platforms.
Migration of Existing Configuration Settings
During the installation process, all of your existing engine configuration values are migrated to the new engine, with several exceptions. The exceptions are documented in Table 5-1.
Table 5-1 Configuration Setting Values not Migrated
|
Configuration Setting
|
New Value
|
|
Server4Debugging4Trace File Location
|
C:\pvsw\bin\mkde.tra [default]; or bin\mkde.tra file in selected installation directory.
|
|
Server4Directories4 Transaction Log Directory
|
C:\pvsw\bin\mkde\log [default]; or bin\mkde\log subdirectory of selected installation directory.
|
|
Server4Compatibility4 Create File Version
|
9.x. By default, new data files are always created in the most recent file format.
|
|
Server4Data Integrity4 Transaction Durability
|
Off. With the addition of a new setting, Transaction Logging (default: On), Transaction Durability is not needed to ensure multi-file transaction atomicity and data integrity. If your application requires true Transaction Durability, you will need to use Configuration to turn this setting On.
|
Installing Over Existing Pervasive Products
- If you are upgrading from older product versions such as Btrieve 6.15 and wish to make use of all the new version features, you must rebuild your data files so they use the v8 or v9 file formats. See the Pervasive.SQL Advanced Operations Guide section for detailed information on how to use the Rebuild Utilities to convert your data files.
- If you install Pervasive.SQL 9 SP1 (9.1) over an existing version such as Pervasive.SQL 2000 or Btrieve 6.15, then those products will be archived when you install Pervasive.SQL 9 SP1 (9.1) so that there are no component conflicts. You can use Pervasive System Analyzer later to restore the archived products if necessary. Your licenses from previous Pervasive products such as Btrieve 6.x and Pervasive.SQL 2000 will not be migrated to Pervasive.SQL 9 SP1 (9.1).
Installation Tips
- When installing Pervasive.SQL 9 SP1 (9.1) for the first time on a system, Setup will check if all of the needed system files meet the minimum requirements. In some cases, these files are locked by the operating system and a reboot is required before Setup can continue. The following dialog box is displayed if this is the case.
Figure 5-1 Pervasive.SQL 9 SP1 (9.1) Setup Reboot Required
Click Yes to reboot the system. Setup is then automatically be restarted.
Note
It is strongly recommended that you reboot your system if you encounter this message. If you do not reboot your system, Setup will encounter failures during engine and utilities configuration.
Accessing README file information
It is highly recommended that you go through the README file to find out the latest changes and additions to Pervasive.SQL 9 SP1 (9.1).
