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 |
Note that starting with database version 7.7, Database Studio replaces Database Manager GUI and SQL Studio, and provides a GUI for the Loader.
|
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 |
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 |
Concepts of the Database System, Architecture of the Database Tools