PreviousUser's Guide (9.1 revision 1) Next

Helpful Utilities

Show this topic in Library frames

The Pervasive.SQL database engines come 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.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


Chapter contents
Publication contents

Prev topic: Understanding the DBMS Products
Next topic: Using Pervasive.SQL Documentation