PreviousGetting Started with Pervasive.SQL 9 (Server Edition) (9.1 revision 1) Next

Upgrading to Pervasive.SQL Server from Earlier Pervasive.SQL Versions or Btrieve 6.x

Show this topic in Library frames

You must install the Pervasive.SQL Server upgrade at the server itself; you cannot install it remotely from a client machine.


Note
If the installation fails before the program copies any files to the target installation directory, the installation log file (psqlinst.log) can be found in the directory specified by the %TEMP% environment variable. This directory is often c:\windows\temp or c:\winnt\temp.

To upgrade to Pervasive.SQL Server:

  1. Launch the installation selection program from your Windows machine.
    1. Insert the Pervasive.SQL Server for Windows CD in the CD-ROM drive of your Windows server.
    2. If the installation does not start automatically, click Start then Run, and type drive:\autorun\autorun where drive is the drive letter of your CD-ROM device.
    3. The installation selection dialog displays.

  2. Click the button for the "Server" installation.
  3. The installation program begins its initial preparation. After the preparation completes, the Welcome screen appears.

    If a dialog appears advising you that a reboot is required, see Installation Tips .

  4. Click Next to proceed with the installation.
  5. Read the Software License Agreement.
  6. Click the "accept" option to enable the Next button.
  7. Figure 7-1 Pervasive Software's Software License Agreement



  8. Click Next.
  9. A dialog appears on which you specify a license key.

  10. Type, or paste, a license key into the License field, or install the default evaluation license.
  11. Figure 7-2 Applying the User Count License



    Your Pervasive.SQL 9 SP1 (9.1) Server is set to the number of users specified in the license key.


    Note
    If you do not yet have a license key or it is not with you at the moment, you can still continue with the installation by using an evaluation license. Click Next to evaluate the product for a trial period The trial version license is valid for 30 days, then expires.

    You may run the License Administrator utility at a later time to view or install a user count license key. The License Administrator utility is documented in Pervasive.SQL User's Guide in the section License Administrator .
  12. Click the setup type desired: Complete or Custom (the default is Complete).
  13. Figure 7-3 Setup Type Dialog Box

    The Complete installation, which is recommended for most users, takes default actions for operations performed during the installation. The Complete server installation installs the following components to drive C:

    • Pervasive.SQL 9 SP1 (9.1) engine (including ODBC interface)
    • Client requesters (MS-DOS, Win32)
    • Pervasive.SQL Control Center
    • Utilities
    • Transactional and Relational interfaces
    • Online documentation in JavaHelp format

    • Note
      Client installation images for Windows and Linux are not part of the server installation. You must run a separate installation program for Pervasive.SQL clients. See Installing Pervasive.SQL Clients for Windows for more information.

      The Custom installation is typically for advanced users. It allows you to specify the installation location, select the components to install, and determine the space requirements for the components.

  14. Click Next, then continue based on your choice of Complete or Custom:
    • If you choose a Complete install, continue with the next step.
    • If you choose a Custom install, skip now to Custom Installation Path . At the end of that section you will return to this set of steps to continue the installation.
    • At this point, if you want, you may click Back to change or review any of the installation settings, or click Cancel to exit the installation program. After you click Install, you may still exit the installation, but you will be unable to change or review settings.

  15. Click Install.
  16. If required, close any running applications that may interfere with the Pervasive.SQL installation. A dialog box appears if applications are running that can interfere with the installation of Pervasive.SQL.

    Figure 7-4 Example Dialog Box for Programs that May Interfere

    Decide how to continue with the installation. Your choices are:

    1. To exit all of the programs that may interfere, then click Next.
    2. Not to exit all of the programs that may interfere, then click Ignore.

    3. Note
      Next does not proceed with the installation unless you exit all programs that will interfere.

      If you wish to leave one or more programs running that may interfere, you must click Ignore to continue. Unpredictable results may occur during the Pervasive.SQL installation if you ignore programs that may interfere.

      If no running applications interfere with the Pervasive.SQL installation, the installation process continues. A dialog box appears that gives you a status.

      Figure 7-5 Installation Status Dialog Box

      Installation actions include, but are not limited to, the following:

    4. Script operations
    5. Component registration
    6. File copying
    7. Shortcut creation
    8. System registry updates
    9. Sample database creation
    10. After the initial actions, the installation process launches the Pervasive System Analyzer (PSA) Wizard. The PSA Wizard allows you to test the transactional and relational interfaces. These tests ensure that your database engine is working as expected.

      By default, the option for the transactional tests is selected.

      Figure 7-6 Transactional Engine Test



  17. Click Next to run the transactional tests and to see the results.
  18. PSA performs a series of tasks to ensure that the transactional engine is working properly.

    PSA displays a check mark for each test that passes and an X for each task that fails during the transaction engine test. A summary report is also provided in the information window, as shown in the following figure.

    Figure 7-7 Transactional Engine Test Results from PSA



  19. Once your transactional tests are successful, click Next to proceed with the PSA Wizard.
  20. PSA is now ready to ensure that the relational engine is working properly.

    Figure 7-8 Relational Engine Test



    Note that the tests use your current machine name and the sample demodata database. Use these values unless you specifically wish to test a different database. To test a different database, enter the Machine Name and Engine DSN for the engine data you want to test.

  21. Click Next to run the relational tests and to see the results.
  22. PSA displays a check mark for each test that passes and an X for each task that fails during the relational engine test. A summary report is also provided in the information window, as shown in the following figure.

    Figure 7-9 Relational Engine Test Results from PSA



  23. Once your relational engine tests are successful, click Next.
  24. The final dialog of the PSA Wizard displays and provides a summary of the tasks completed by the Wizard.

    If you want to view the PSA log file, it is named by default PSALog.txt and is located by default at <OSdrive>\Program Files\Common Files\Pervasive Software Shared\PSA, where <OSdrive> is the drive letter where your operating system is installed.

  25. Click Finish to complete the PSA Wizard.
  26. The final dialog of the Installation Wizard displays along with a registration page.

  27. Register your product.
  28. Pervasive Software recommends that you register your product to receive news about future updates, and other timely information. You can also register later using a web, e-mail, or print-based registration form.

    Figure 7-10 Product Registration Page

    If you did not read the README file prior to installation as described in Before You Begin , please do so now from the registration page.

  29. Click Readme on the registration page to read the README file.
  30. Figure 7-11 View Readme

  31. Close the Registration page (click the "X" in the upper right corner).
  32. Click Finish to complete the Installation Wizard.
  33. If installed files could not be copied because they were locked in memory, a reboot may be necessary at this point. Setup only prompts for a reboot if a locked file or some other event was detected that requires a reboot. Please reboot your system if prompted to do so in order to ensure proper operation of your Pervasive.SQL 9 SP1 (9.1) product.


    Note
    If you have any trouble with the installation, see Chapter 19, Troubleshooting After Installation.

    The installation program modifies the PATH and CLASSPATH environment variables at the end of the installation process. These settings control how your Windows operating system finds Pervasive components. OnWindows 32-bit platforms, these environment variables are stored in System information, which you access from the Control Panel.

    Thank you for choosing Pervasive.SQL.

What to do Next

See Common Questions After Installing Pervasive.SQL .


Chapter contents
Publication contents

Prev topic: Before You Begin
Next topic: Custom Installation Path