Background documentationDatabase Tools Locate this document in the navigation structure

 

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

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

Synchronization Manager

This software is no longer delivered as a separate tool (last delivery with version 7.6).

GUI

Synchronizing table contents of two or more databases.

Database users

No

Web DBM

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

SAP customers can find more information in SAP Note 856940 (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 (Ordering Web Tools).

Command line

Web browser