We currently use Sybase and DB Artisan (8.12) from Embarcadero on a PC
runing Windows

DB Artisan is overkill for my needs, as all I need is:


1 - the ability to run queries, sort the result set on screen, cut &
paste to Excel


2 - an autocomplete feature where if I alias a table (example - from
deal_master dm) then I can type the alias . and a box pops up with
valid column names


3 - the ability to search objects for a name (example - all tables /
views /stored procedures containg the column "main_account")

I do not need a gui that helps me join tables (i.e. the GUI in MS Query
in Excel)


I am unhappy with the slowness of DB Artisans search speed (the older
versions seemed much faster) and also the autocomplete mysteriously
stops working. I use 8.12


What are some good alternative products that would meet my needs?

On 26.01.2007 16:21, usawargamer (AT) yahoo (DOT) com wrote:
You could do it directly from Excel. For the searching of tables /
columns you can query system tables / views.

Just my 0.02EUR...

robert

I may not have been clear.
Excel has MS Query which is very limited, and I'd rather not use it.
MS Query doesn't show you what tables / views / triggers / stored
procedures are available in each database and server.



On Jan 26, 11:13 am, Robert Klemme <shortcut... (AT) googlemail (DOT) com> wrote:

On Jan 26, 4:21 pm, usawarga... (AT) yahoo (DOT) com wrote:
You could check out:

http://squirrel-sql.sourceforge.net/

I haven't used it very much myself, but others seem happy with it. It
has completion (don't know if it meets your needs though). Another
thing I like about it is the possibility to validate sql stmts against
mimers sql validator service.

As mentioned I haven't used it very much, but it is free of charge so
you can determine for your self whether it meet your needs.

/Lennart

On 26.01.2007 17:34, usawargamer (AT) yahoo (DOT) com wrote:
.... and I said that you can query system views / tables to get at that
information. :-)

robert

usawargamer,

Even though you don't need the join capabilities, MS Query has drag and drop
capabilities for columns. Is that not workable?

SourceForge.net probably has a couple of query builders.

-- Bill

<usawargamer (AT) yahoo (DOT) com> wrote