An Introduction to the EnterpriseDB Toolset
Oracle Tips by Burleson Consulting
EnterpriseDB Toolset comprises six main components: Database Server,
Developer Studio, PL Debugger, Remote DBA Management Server, Replication Server
and Migration Toolset. In this section, I will introduce each component
and describe some of their more important functions.
I will cover each
topic in greater detail in later chapters. I am not going to discuss the
database server at this point. All of the components that I discuss in this
section run on top of the database server. Everything up to this point, and
everything after this point, is really all about the database server.
This section is
not going to go into the fine details of how each component works. It is just
meant to outline the major functionality of each component.
Figure 2.21, is an IDE for EnterpriseDB developers. Developer Studio allows a
developer to browse databases, write and tune SQL and EnterpriseDB SPL code and
perform some limited system administration functions (such as backup and
is an Open Source Java program. You can download the source code from
EnterpriseDB.com. Because it is a Java program, the program works, and looks,
the same on each platform supported by EnterpriseDB.
can connect to Oracle databases, EnterpriseDB databases and PostgreSQL
databases. Using Developer Studio, a developer also has the ability to view
PL/SQL (in Oracle), write and compile EnterpriseDB SPL (in EnterpriseDB) and PL/pgSQL
(in EnterpriseDB and PostgreSQL). Developers can also write and tune SQL
The main areas of
Developer Studio (Figure 2.21) are the menu and toolbar (area 1), the navigator
pane (area 2), the properties pane (area 3), the SQL pane (area 4), the SQL
Interactive window, and Visual Explain. Less used areas are EnterpriseDB PSQL,
a SQL*Plus-like command line SQL editor, backup and restore and the connection
configuration screen. The PL Debugger is integrated into Developer Studio but
is a separate component.
Explain, the PL Debugger and EnterpriseDB PSQL cannot be used with Oracle.
Developer Studio Main Window
Area 1 of Figure
2.21 displays the Main Menu and the Toolbar.
Under the File
menu options are: Add Server adds a new database server; and Exit.
Under the SQL Menu
Options are: the SQL Interactive tool (Figure 2.23) allows a person to enter
and run queries, and write and compile code; SQL Terminal run the command line
SQL Editor; Visual Explain allows a developer to see a graphical explain plan
for performance tuning; and View Data which uses the SQL Interactive tool to
run a SELECT query against a specific table.
Under the Tools
Menu Options are: Backup and Restore; options to run the debugger and set
debugger break points; and Preferences set the default exit behavior of SQL
Interactive (commit, rollback, or always ask) and configure the command to start
the SQL Terminal.
Under the Help
menu options are options to connect to the EnterpriseDB web site and view the
online help or view an About box.
On the toolbar,
Figure 2.22, are several icons: Server add, edit, copy or remove a server
connection, Refresh requery the navigator and repaint the screen, Create
Object create a new object of the type highlighted in the navigator pane, Drop
Object drop the object highlighted in the navigator pane, SQL Interactive
launch the SQL Interactive tool, SQL Terminal Launch the SQL Terminal, Visual
Explain launch the Visual Explain tool, and the an icon for the debugger and
an icon for setting a debug breakpoint.
This is an excerpt
from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.