Re: [aus-dotnet] Database Query Editor

[noonie]

Greetings,

On Wed, 08 Dec 2004 11:19:28 +1100, Anderson, Dale
<dale.anderson@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Hi All,
> 
> Can anyone recommend a good database independent SQL query editor?
> Something with functionality similar to SQL Server Query Analyzer but
> with the ability to connect to any OLE or ODBC data source (in
> particular Oracle 8/9, Oracle RDB7, MS Access and SQL Server? I don't
> want visual query design, and don't expect it to map execution plans
> etc. Minimum requirements are a query editor with RELIABLE connectivity,
> syntax highlighting, grid or text based results with cut and paste,
> object browsing and results exporting. Oh and it must have a trial
> period...
> 
> I have tried many different ones and cannot find one that fits my
> requirements, the main problem being database connectivity.
> 
> Been tempted to write one, but it's a big job and there's too much
> drinkin' to be done on the weekend :)
> 

How about Visual Studio .NET (2003)?

Database projects can use any of a number of connection types
including various ODBC connections.

I successfully used an earlier version of Visual Studio with Oracle
for statement editing but can't remember how good it was with syntax
highlighting. I do remember having some problem with manageing
Oracle-only objects but if you only want to edit queries then VS 2003
does come with a syntax engine for PL/SQL.

If you already have an Oracle client installed then you get the
"provider" and with Visual Studio installed it's not going to cost you
much more than time to try it out.

Regards,
Neale NOON
_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com