Enterprise Manager & Database Navigator

If you want a good overview of your servers and databases, use the Enterprise Manager. For each working connection, you will see a new Database Navigator. You can connect to as many database as you want.

Server Specific Functionality

The Enterprise Manager is your gateway to database engine specific functionality like Server Processes, User Management or Backup/Restore functionality.

Databases

A list of available or registered databases is available and you can connect from here. Connect to as many databases as you like: each connection will open a Database Navigator.

Database Navigator

With the Database Navigator, you can see all database object, nicely organized in a tree. Double click or right click offers you a great deal of functions available or opens the right editor for the selected object. And what's even better, if you have selected, for example, an index, expand the node to see to what table it belongs. The tree is fully recursive! You just cannot get lost in your database!

Statement Recording

One of the great tools available is the recording of DDL and SQL statements that are executed on a connection. Use it to keep track of your changes and queries, use it to compile a script that you have to run at remote sites to bring your database structure to the same level. Use it for whatever you like, you have it available!

Extract Metadata

You can extract your metadata statements right from the tree - just click the 'extract DDL' button and off you go. Extract the complete database, just the tables etc etc. A dialog with additional options will be displayed or use the DDL Extract Wizard which allows you to select each object you want to extract.

Always keep a copy of your database metadata - and generate it with Database Workbench.

Server Specific Functionality

From the Database Navigator, you have access to server specific functionality related to databases. For example, for InterBase, there are monitoring features, while MS SQL Server offers table fragmentation and space usage information.