Table 2-1 Summary of Pervasive.SQL Utilities
|
Utility name
|
Runs on these platforms
|
Description
|
Server or Workgroup
|
|
Pervasive Control Center
|
Win32
|
Utilities warehouse for Pervasive.SQL 9 SP1 (9.1). Shows list of engines and databases available.
|
All
|
|
Configuration property dialogs within PCC
|
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 works or test and debug an application.
|
All
|
|
Maintenance
|
DOS, Win32 and NetWare
|
Performs common Pervasive.SQL file and data manipulations, such as importing and exporting data. BUTIL - command line version.
|
Windows 32-bit and NetWare servers
All 32-bit Windows workstations and Linux for command-line version
|
|
SQL Editor - invoked within PCC
|
Win32
|
Allows you to execute SQL statements interactively.
|
All
|
|
Table Editor - invoked within PCC
|
Win32
|
Allows you to editor table schemas.
|
All
|
|
License Administrator Utility
|
Win32, NetWare, and Linux
|
Manages Pervasive.SQL license keys and user counts.
|
Windows, NetWare, and Linux servers remotely
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 configuration files for the workgroup engine.
|
Workgroup engine only
|
|
Pervasive System Analyzer
|
Win32
|
Analyzes system components, runs communication tests, and archives or restores database engine files on your system.
|
All
|
