Show TOC

Database ToolLocate this document in the navigation structure

Use

Database tools are programs that you can use to manage and monitor databases, to edit data and to handle errors.

There are various database tools available for SAP MaxDB.

Table 1: SAP MaxDB Database Tools

Name

User Interface

Tasks

Typical Users

Downward Compatibility

Database Analyzer

Command line

Analysis of the performance of databases

Support employees

Database administrators

Yes

Database Manager CLI

Command line

Creating and managing databases, DBM operators and database users

Database administrators

Yes, ≥ 7.2

Database Studio

GUI

Note that starting with database version 7.7, Database Studio replaces Database Manager GUI and SQL Studio, and provides a GUI for the Loader.

  • Creating and managing databases, DBM operators and database users

  • Exporting and importing data, tables, schemas, users, and databases

  • Accessing data and the database catalog, SQL statements, creating, and managing database objects and database users

  • Synchronizing table contents of two or more databases.

Database administrators

Yes, ≥ 7.5

Loader

Command line

Exporting and importing data, tables, schemas, users, and databases

Database administrators

Application developers

Yes, ≥ 7.3

SQLCLI

Command line

Accessing data and the database catalog, SQL statements, creating, and managing database objects and database users

Database users

Application developers

Yes, ≥ 7.2

XCONS

Command line

Database console. Displaying detailed information about the operating system resources occupied by the database system

Support employees

Database administrators

Yes

XUSER

Command line

Creating and managing XUSER entries for simplified logon to database tools and interfaces with user keys

Support employees

Database administrators

Application developers

Yes

Table 2: Other SAP Database Tools

Database Tool

User Interface

Tasks

Typical Users

Downward Compatibility

GUI

Managing SAP MaxDB and SAP liveCache databases in SAP systems

Note that CCMS is only available in SAP systems.

SAP administrator

Yes

More Information

Concepts of the Database System, Architecture of the Database Tools