Database Tool 
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.
Name |
User Interface |
Tasks |
Typical Users |
Downward Compatibility |
|---|---|---|---|---|
Command line |
Analysis of the performance of databases |
Support employees Database administrators |
Yes |
|
Command line |
Creating and managing databases, DBM operators and database users |
Database administrators |
Yes, ≥ 7.2 |
|
GUI |
From database version 7.7, Database Studio replaces Database Manager GUI and SQL Studio, and provides a GUI for Loader. End of the note.
|
Database administrators |
Yes, ≥ 7.5 |
|
Command line |
Exporting and importing data, tables, schemas, users and databases |
Database administrators Application developers |
Yes, ≥ 7.3 |
|
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 |
|
Command line |
Database console. Displaying detailed information about the operating system resources occupied by the database system |
Support employees Database administrators |
Yes |
|
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 Browser |
Accessing data and the database catalog, SQL statements, creating and managing database objects and database users |
Database users Application developers |
Yes |
NoteDatabase 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