 |
|
EnterpriseDB: Navicat
Oracle Tips by
Burleson
|
Navicat
Available at:
http://pgsql.navicat.com
Navicat
is the most feature rich of all the tools in this chapter but it does
not have a free version. You can download a fully functional
trial version from the site above.
It has a
very familiar interface and is very easy to use. I like the fact
that it has code completion and the query builder is very nice for new
users. Of all the products, it is the only I have found that has
an integrated scheduler.
You will
perform all of the familiar steps with this tool that you do with the
others: add a server, browse databases in a navigator tree, etc.
The main screen is laid out very efficiently (Figure 5.66).
Figure
5.66: Navicat Main Window
I almost
wish that at least one of the tools had chosen a different paradigm
for navigating database objects. The tree view is probably the
most efficient and/or easy to learn but it would be nice to mix it up
a bit.
Viewing
data in Navicat follows the familiar Developer Studio and pgAdmin
method of popping up a new window (Figure 5.67). I prefer the
SQL Manager method of having the data available with a tab click.
Figure
5.67: Navicat View Data
Creating
and running queries takes a new turn in Navicat though. The
query builder (Figure 5.68) can make life much easier for those new to
databases or new to an application.
Figure
5.68: Navicat Query Builder
The
query text is populated as you select tables and columns. Adding
relations is as easy as drag and drop. You can view the
completed query in the Query Editor tab (Figure 5.69).
Figure
5.69: Navicat Query Editor
When you
run the query (by clicking the Run button), a new tab is created with
the results (Figure 5.70).
Figure
5.70: Navicat View Query Results
The
final feature in Navicat that I wanted to mention is the integrated
scheduler (Figure 5.71). While it may not be a needed feature
for casual users, DBAs and administrators frequently need to schedule
small jobs and having it integrated in the IDE is a nice bonus.
Figure
5.71: Navicat Scheduler
Conclusion
This
chapter covered development in EnterpriseDB Advanced Server with
Developer Studio in full detail. In this chapter, I have shown
how to configure connections to EnterpriseDB, PostgreSQL and Oracle
and how to browse those databases.
Developer Studio will browse Oracle databases but only creates objects
in EnterpriseDB and PostgreSQL. In this chapter, I show how to
use the wizards in Developer Studio to create databases, schemas,
tablespaces, tables, views, sequences, synonyms, users and roles.
You should also be able to drop objects using Developer Studio.
Developer Studio provides many tools useful for developers and DBAs:
*
PL/Debugger to debug procedural code
* Visual
Explain Plan to see a graphic representation of query execution plans
* Backup
and Restore to protect you data
* Online
Migrations of Oracle objects and data to EnterpriseDB Advanced Server
* SQL
and Procedural Code edit tools
As
powerful as Developer Studio is, it may not provide all of the
features you need to be most successful at your job. The chapter
ended with an overview of three third-party IDEs: the free pgAdmin
III, the lite version of EMS SQL Manager and the commercial product
Navicat.
The next
two chapters, EnterpriseDB Management Server and EnterpriseDB
Replication, will complete the coverage of the EnterpriseDB toolset.
This
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress. |
