Database Tools - SAP Documentation

Database Tools

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

Other SAP Database Tools
Database Tool	User Interface	Tasks	Typical Users	Downward Compatibility
DBA Cockpit Further CCMS Tools: Database Administration in CCMS	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
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
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

More Information