Pervasive logo

Prev User's Guide Next

Helpful Utilities


Pervasive.SQL comes with a variety of utilities designed to help you control and manage your databases. Most of the utilities run only on 32-bit Windows and allow remote function to NetWare or Linux database server engines.

 
Table 1-2 Summary of Pervasive.SQL Utilities

Utility name
Runs on these platforms
Description
Server or Workgroup
Pervasive Control Center
Win32
Utilities warehouse for Pervasive.SQL. Lists engines and databases available.
All
Configuration
Win32
Manipulates settings for Pervasive client and server components.
All
Monitor
Win32
Monitors server engine activity. Useful for database administration and programming diagnostics.
All
Function Executor
Win16, Win32
Executes Btrieve operations, enabling you to learn how the Btrieve interface operates on data files.
All
Pervasive.SQL Maintenance
Linux, Win32, and NetWare
Performs common Pervasive.SQL file and data manipulations, such as importing and exporting data.
Linux, Windows, and NetWare servers

All 32-bit Windows workstations for GUI version
SQL Data Manager
Win32
Allows you to execute SQL statements interactively.
All (local)
Server (remote)
Table Designer
Win32
Allows you to add, delete, or change the characteristics of columns within a table, and to create a database or a table.
All (local)
Server (remote)
Rebuild
Win16, Win32, and NetWare
Converts one version of MicroKernel files into another version.
Windows and NetWare servers

Windows 32-bit workstations
License Administrator
Win32, NetWare, and Linux
Manages Pervasive.SQL license keys and user counts.
Windows, NetWare, and Linux servers (remote)
Workgroup (local)
Command-line version on Windows, NetWare, and Linux
ODBC Administrator
Win32
Sets up Data Source Names (DSNs) for client and engine interfaces.
All Windows engines (local)
Server (remote)
Gateway Locator
Win32
Used to configure and maintain gateway locator files for the Workgroup engine.
Workgroup engine only
Pervasive System Analyzer
Win32
Analyzes system components, runs communication tests, and archives or restores previous database engine files on your system.
All


Prev
Understanding the Product Family
Contents
Up
Check for Revisions
Next
Using Pervasive.SQL Documentation