Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

Customers
SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation
Download Buy

DB2 Maestro online Help

Prev  Return to chapter overview Next 

Working with databases

After you have created the required database profiles (Create Database Profile Wizard) they appear in the explorer tree on the left. Now you can establish connection to the database. If connection succeeds, the database node expands displaying the tree of its objects.

 

Now you can perform all the necessary DB2 admin routines such as creating, editing, copying, extracting and dropping database objects, design your database as ER diagram, build queries visually, execute queries and SQL scripts, accomplish database administration operations in a few mouse clicks, view and edit data including BLOBs, represent data as diagrams and pivot grids, analyze information summarized into OLAP cubes, export and import data to/from most popular file formats, manage server security features, and use a lot of other admin tools designed for making your work with DB2 server comfortable and efficient.

 

 



Prev  Return to chapter overview Next