Installation Overview

---

This section provides an overview to the components that make up Pervasive.SQL V8. Also included in this section is information on the files included in the different types of installation.

Major Components of Pervasive.SQL V8

Pervasive.SQL V8 consists of the following components:

Pervasive.SQL V8 Database Engine

Pervasive.SQL V8 consists of two database sub-engines:

• MicroKernel Database Engine (MKDE), which provides Btrieve/MicroKernel API support for Pervasive.SQL applications
• SQL Relational Database Engine (SRDE), which provides ODBC/SQL API support for Pervasive.SQL applications

Client

Requesters that allow you to access the server-based MicroKernel from a DOS or 98/ME/NT/2000/XP client.

• The 16-bit requesters used in DOS clients are Btrieve requesters only and will have no relational access.

Pervasive.SQL V8 Utilities

Pervasive.SQL V8 includes a suite of useful utilities for every phase of database management from engine installation and configuration to data maintenance. They include the following:

• Pervasive System Analyzer (PSA)
• Pervasive Control Center (PCC)
• Configuration
• Monitor
• License Administrator
• Function Executor
• Maintenance
• SQL Data Manager
• Table Designer
• Rebuild
• ODBC Administrator
• Gateway Locator

Wizards

As part of the tools available in PCC, a suite of wizards provide an interactive way to assist you in database development, maintenance, and manipulation. Wizards available in Pervasive.SQL V8 include the following:

• Create Database
• Drop Database
• Check Database
• Import Data
• Export Data
• Null Conversion
• Create Table
• Drop Table

Online Documentation

In addition to context-sensitive help for the utilities, you can install the complete Pervasive.SQL V8 documentation set in HTML Help format. Your product package contains a printed copy of Getting Started with Pervasive.SQL V8 (Server Edition) and the Status Codes and Messages Quick Reference card. You can order a complete hardcopy set of the manuals through the Pervasive Software Sales Team.

• What's New in Pervasive.SQL V8 - describes the new features in the release.
• This book - Getting Started with Pervasive.SQL V8 (Server Edition) - helps you to get Pervasive.SQL V8 Server engine running with installation, setup, and basic configuration information based on your operating environment.
• Getting Started with Pervasive.SQL V8 (Workgroup Edition) - helps you to get Pervasive.SQL V8 Workgroup engine running with installation, setup, and basic configuration information based on your operating environment.
• Pervasive Products and Services - provides an overview of Pervasive Software products and services, including support options and information regarding licensing and registration. This manual also describes the database and product architectures.
• Pervasive.SQL User's Guide - gives basic information on the utilities provided with the Pervasive Control Center, including several interactive wizards designed to help you accomplish basic database tasks. This manual also contains information on the Linux database engine and the utilities available for that particular platform.
• SQL Engine Reference - provides database programmers a complete reference guide to the SQL relational database language supported in Pervasive.SQL V8.
• Advanced Operations Guide - details tasks typically performed by Network or System Administrators, using various tools such as the Rebuild, Maintenance, Monitor, and Function Executor utilities.
• Status Codes and Messages - lists the error and informational codes and messages that can be received when using Pervasive software.

Installation Options

Pervasive.SQL V8 offers Complete and Custom installation options. You can accept default installation parameters by selecting the Complete install, or you can specify certain installation parameters by selecting the Custom install option. The following sections outline the major differences in these two installation options.

Complete Setup Installation

The Complete installation, which is recommended for most first time users, takes default actions for most operations performed during the installation.

The Complete setup installs the following components:

• Pervasive.SQL V8 Engine (including ODBC interface)
• All possible requesters (Win32 and MS-DOS requesters)
• Utilities
• Transactional and Relational interfaces
• Client installation copies
• Online documentation

Custom Setup Installation

Selecting Custom setup type allows you to specify the program folder name, select the components to install, and set the Pervasive.SQL V8 engine service start mode.

During a Custom server installation, the following components are optional:

• Online documentation
• Client installation programs for DOS and Windows.

On Windows, the default installation location for Pervasive.SQL V8 is C:\PVSW, assuming the Windows system drive is C.

On NetWare, the default installation location is SYS:\SYSTEM.

On Linux, the default installation location is /usr/local/psql.