Background documentationDatabase Tool Locate this document in the navigation structure

 

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.

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 Note

From database version 7.7, Database Studio replaces Database Manager GUI and SQL Studio, and provides a GUI for Loader.

End of the note.
  • 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

Web SQL

Web Browser

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

Database users Application developers

Yes

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