hi duilio,
you have right, i am also not happy with the existing admin-tools.
For the daily work (developing) you have to use not only one tool,
you need nearly all ...

What i need for my daily work?

- easy browsing tables, data (with 3 mouseclicks) (70% of use)
- easy extract metadate (in a Delphi-Create-format as choice) (10% of use)
so i can copy and paste ...
- easy create new dbs, tables, indexes, generators, stored procedures ... (5% of use)
- duplicate tables (with all, indexes, data, and so on) (1% of use)
- one click to set statistics on all indexes ... (5% of use)
- import data, export data (1% of use)
- documenting (html) (1% of use)
- graphical-relationship -> print (important for thinking about the db)
- DB-service tools, as backup, restore, sweep .. (5% of use)
- this all combined with a modern human interface ...

The SQL-Explorer from Borland in my first choice till today,
whether i have to kill it often, and it cannot many things.
This tool i need (70%), therefore first choice ..

All what this tool not can, i have to search in 5 other admin-tools.
Some can this, some can that ...

Some things i made now self (set statistics an all existing indexes,
in the xxx.gdb, p.e. what can very increase the performance)
-> the first step, if you want more performance on an existing db,
with a lot of data !!!

okay, if i have more time, i will make my own admintool,
based on Firebird and IBO ..., the target group are
developers that use Firebird, not only db-admins.

I hope also IBO will complete the components, for the
API-Service. i cannot use IBX for it, because IBX will not
support Firebird ...

- gerhard

----- Original Message -----
From: Duilio Foschi
To: ib-support@yahoogroups.com
Sent: Saturday, January 26, 2002 9:49 AM
Subject: [ib-support] poor administration tools


until now, I have tried WISQL, IB_SQL and IBAdmin.

None of them seems able to answer this simple question:

given a certain table A that I want to drop, which are the tables that have
constraints on A (and that prevent me from dropping the table) ?

Is it difficult to answer such a question ?

All products are ready to tell me the number of dependencies on A (and
their names), but this is only the starting point...

Is there a really good, user friendly administration tool for IB ?

Thank you

Duilio Foschi


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]