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 V8. Shows list of engines and databases available. |
All |
| Configuration - invoked 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 |
| Pervasive.SQL Maintenance |
DOS, Win32 and NetWare |
Performs common Pervasive.SQL file and data manipulations, such as importing and exporting data. BUTIL - command line version. |
Windows NT and NetWare servers
All 32-bit Windows workstations and Linux for command-line version |
| SQL Data Manager - invoked automatically within PCC |
Win32 |
Allows you to execute SQL Statements interactively. Creates and maintains Data Dictionary Files (DDFs) and database files. |
All |
| Rebuild |
Win16, Win32, and NetWare |
Converts previous versions of MicroKernel files into more recent versions. |
Windows and NetWare servers
Windows 32-bit workstations
Command-line version on Linux |
| 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 |
