EMS logo

Produkt Navigation

SQL Manager for DB2

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for DB2

Online Bedienungsanleitung

Database Tools


SQL Manager for DB2 provides a number of powerful tools that allow you to perform various operations over your databases.

 

SQL Monitor

Displays all the SQL statements executed while working in SQL Manager for DB2.

 

SQL Script Editor

Executes SQL scripts in the database.

 

Search in Metadata

Provides quick search for a string within the scope of database metadata.

 

Extract Database Wizard

Extracts the table metadata and/or data to an SQL script which can be executed later on another machine to restore the database structure and/or data.

 

Activity Monitor

Displays all current connections to a database.

 

Print Metadata

Creates powerful metadata reports in the WYSIWYG mode ready for printing.

 

HTML Report

Creates powerful metadata reports in the HTML format.

 

Reports management

Tools for efficient management of reports: creating, editing, viewing, printing.

 

Dependency Tree

Allows you to view all the object dependencies in one diagram.

 

CLP Console

Allows you to execute the DB2 CLP commands.

 

Compare Databases

Creates an SQL script that provides database structure synchronization.

 

Grant Manager

Allows you to manage grants on your DB2 database objects.

 

Visual Database Designer

Allows you to lay out your database schema visually.

 

Project Interaction

Creates projects which allow you to work with virtual databases that do not require connection to the server.

 

External Tools

Allows to add external Windows applications.

 

Using templates

Facilitates using SQL Manager wizards.

 

 


See also:

Getting Started

Database Explorer

Database Management

Database Objects Management

Query Management Tools

Data Management

Import/Export Tools

Change management

Instance Services

Personalization

How To...