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
|