Tool | Description | GUI Available | Windows | Linux or macOS | ||
Server | Client | Server | Client | |||
Configures PSQL components | PSQL Control Center (see
Configuration Reference in Advanced Operations Guide) | Yes | Yes | Yes | Yes | |
Imports data into a database | No | Yes | No | Yes | No | |
Monitors PSQL activity | Monitor tool (see
Monitoring in Advanced Operations Guide) | Yes | Yes | |||
Creates and administers database user names and passwords | No | No | No | Yes | No | |
Repairs and manipulates data files | Maintenance tool (see
Manipulating Btrieve Data Files with Maintenance in Advanced Operations Guide) | Yes | Yes | Yes | Yes | |
w64clilcadm (Windows 64-bit) clilcadm64 (Linux or macOS 64-bit) | Applies and administers user licenses. | License Administrator (see
License Administration) | Yes | No | Yes | No |
w64clipaadm (Windows 64-bit) clipaadm64 (Linux or macOS 64-bit) | Phone authorization tool used to authorize product keys when an internet connection is unavailable. (Phone authorization only) | Phone Authorization Wizard opened by running guipaadm at a command prompt | Yes | Yes | Yes | Yes |
Finds and corrects data fragmentation, rebuilds indexes, removes unused space. | Defragmenter (see
Monitoring Data File Fragmentation in Advanced Operations Guide) | Yes | No | Yes | No | |
Creates and administers named databases | No | No | No | Yes | No | |
Creates and administers Engine DSNs on the server | No | No | No | Yes | Yes | |
isql64 (Linux or macOS 64-bit) | Allows you to run SQL statements interactively and test connectivity to a DSN. | No | No | No | Yes | Yes |
w64licgetauth (Windows 64-bit) licgetauth64 (Linux or macOS 64-bit) | Transmits authorization request data and retrieves authorization key data. (Offline authorization only) | No | Yes | Yes | Yes | Yes |
Notification Viewer | Notification Viewer provides two interfaces: system tray icons and a graphical user interface. Although not strictly a CLI tool, it is mentioned here for reference. | See
Notification Viewer in Advanced Operations Guide. | Yes | No | Yes | No |
Manipulates PSQL services | No | Yes | Yes | No | No | |
Configures PSQL components by editing the PSQL registry | No | No | No | Yes | Yes | |
Register PSQL components | No | No | No | Yes | Yes | |
Specifies user names and passwords for secure databases | PSQL Control Center (see
PSQL Security in Advanced Operations Guide) | Yes | Yes | Yes | Yes | |
Processes SQL statements in a command file | PSQL Control Center (see
SQL Editor) | Yes | Yes | Yes | Yes | |
Specifies user names and passwords for remote servers | No | Yes | Yes | Yes | Yes | |
Rebuilds MicroKernel data files. | Rebuild wizard (see
Rebuild Tool GUI Reference in Advanced Operations Guide) | Yes | Yes | Yes | Yes |