Table 1-2 Summary of Pervasive.SQL Utilities
|
Utility name
|
Runs on these platforms
|
Description
|
Server or Workgroup
|
|
Pervasive.SQL Control Center
|
Win32
|
Primary utility for Pervasive.SQL. Lists engines and databases available and allows you to set properties (configure) objects.
|
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 Editor
|
Win32
|
Allows you to execute SQL statements interactively and add or edit data in tables.
|
All (local)
Server (remote)
|
|
Table Editor
|
Win32
|
Allows you to add, delete, or change the characteristics of columns within a table, and to create 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
|