Show TOC

Database ToolsLocate this document in the navigation structure

Use
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

Table 3: Obsolete SAP MaxDB Database Tools

Name

Status

User Interface

Tasks

Typical Users

Downward Compatibility

Database Manager GUI

Since version 7.6, no more new functions have been developed.

Use Database Studio instead.

GUI

Creating and managing databases, DBM operators and database users

Database administrators

Yes, ≥ 7.2

SQL Studio

Since version 7.6, no more new functions have been developed.

Use Database Studio instead.

GUI

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

Database users

Application developers

Yes, ≥ 7.4.00

Web DBM

This software is no longer delivered (last delivery with version 7.5).

SAP customers can find more information in SAP Note 856940 Information published on SAP site(Ordering Web Tools).

Use Database Studio instead.

Web browser

     

Web Server and Web Server Manager

This software is no longer delivered (last delivery with version 7.5).

SAP customers can find more information in SAP Note 856940 Information published on SAP site(Ordering Web Tools).

Command line

Web browser

     

Web SQL

This software is no longer delivered (last delivery with version 7.6).

Use Database Studio instead.

Web browser

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

Database users Application developers

Yes