RHDB Graphical Tools Question

RHDB Graphical Tools Question

[Kent Moya]

Hello,

My company is currently evaluating Red Hat Database as a possible 
alternative to Microsoft SQL Server 2000, which we are currently using. 
  I understand that the RHDB graphical tools are still under 
development, but I was wondering if there was a list of what kinds of 
tools will be made available under this suite.  The reason I am asking 
this is because one of the SQL Server tools we use most heavily here is 
the "Query Analyzer", and the availability of a comparable tool in RHDB 
would play a big part in our decision as to whether or not we can switch 
to RHDB.

We use Query Analyzer for testing SQL Statements, building and editing 
functions and stored procedures, updating tables, and almost everything 
else you would ever issue an SQL command for.  It has been an invaluable 
tool for our developers as well as some of our "power users".

If such a tool is under development for RHDB, I would love to hear about 
it!  As I said, we are very seriously considering alternatives to SQL 
Server, and the existence of a comparable replacement for Query Analyzer 
in RHDB would give a lot more weight to the argument for us to switch to 
RHDB.

Thank you in advance for any information you can provide in this area. 
Please feel free to contact me at this Email address if you have any 
questions.

Kent Moya

Re: RHDB Graphical Tools Question

[Patrick Macdonald]

Hi Kent,

Query Analyzer is an all encompassing tool.  The RHDB tools are
mainly for DBA-type administrative tasks.  However, a large 
percentage of the QA functionality is available in the RHDB 
Administrator and Visual Explain tools.  The RHDB Administrator
can create/manipulate/remove objects (databases, tables, indices,
etc) and entities (users and groups) within clusters. Visual 
Explain can be used to analyze query plans.

As for future releases of the RHDB Graphical Tools, we are looking
at configuration tools, extending the current suite's administrative
task functionality (backup, restore, import, etc), and other non
application development tools.  We have no plans at the moment to
develop an application builder.

That said, RHDB is powered by PostgreSQL and many of tools for 
written for PostgreSQL can be used with RHDB.  For a community 
list of tools, visit:

http://techdocs.postgresql.org/oresources.php

Cheers,
Patrick  

Kent Moya wrote:
> 
> Hello,
> 
> My company is currently evaluating Red Hat Database as a possible
> alternative to Microsoft SQL Server 2000, which we are currently using.
>   I understand that the RHDB graphical tools are still under
> development, but I was wondering if there was a list of what kinds of
> tools will be made available under this suite.  The reason I am asking
> this is because one of the SQL Server tools we use most heavily here is
> the "Query Analyzer", and the availability of a comparable tool in RHDB
> would play a big part in our decision as to whether or not we can switch
> to RHDB.
> 
> We use Query Analyzer for testing SQL Statements, building and editing
> functions and stored procedures, updating tables, and almost everything
> else you would ever issue an SQL command for.  It has been an invaluable
> tool for our developers as well as some of our "power users".
> 
> If such a tool is under development for RHDB, I would love to hear about
> it!  As I said, we are very seriously considering alternatives to SQL
> Server, and the existence of a comparable replacement for Query Analyzer
> in RHDB would give a lot more weight to the argument for us to switch to
> RHDB.
> 
> Thank you in advance for any information you can provide in this area.
> Please feel free to contact me at this Email address if you have any
> questions.
> 
> Kent Moya