Re: TOAD vs. SQL Developer vs. what / Using TOAD 7.x against Oracle 10g server and an 11g client

On May 29, 6:19 am, dana_at_w..._at_yahoo.com wrote:
> Here's my dilemma:
>
> * Love TOAD. Been using TOAD 7.x. Recently upgraded to 10g servers
> with 11g clients and TOAD no longer works. The latest TOAD will work
> (9.x), but our budget got slashed so no purchase.
>
> * Been using Oracle's SQL Developer as a TOAD replacement. Love that
> Oracle's finally made a TOAD-like, free product. And I'm truly
> grateful it's in development. But I hate that it's a bit buggy (I have
> to shuffle between versions 1.5.1, 1.5.3, and 1.5.4 to get things
> done), that it takes a long time to launch (TOAD was faster), that it
> has no Load / Save button in its visual query builder (I don't use
> this feature much, but my colleagues rely on it heavily), and that it
> has limited schema comparison capabilities.
>
> I'm wondering:
>
> 1. Is there any way to get TOAD 7.x to work with Oracle 10g servers
> and 11g clients? Seems older versions of TOAD (e.g. 6.x) work with our
> present configuration, but I don't want to go even further back in
> time.
>
> 2. What else is out there, either free or "affordable" (affordable
> being USD $150 or less per license), that:
>
> -- Includes a graphical query builder (like TOAD's SQL Modeler)
> -- Launches fast
> -- Can do schema comparisons between any two schemas (possibily
> differently named) on any two servers, without having login
> credentials for those two schemas--TOAD does well with this as long as
> one has the requisite object permissions (naturally)--SQL Developer
> requires you to have the u/ns and p/ws for both schemas being
> compared, and requires them to be named the same.
> -- Preferably does *not* rely on the DBMS_METADATA package to extract
> DDL (which requires you have the un/pw to a schema rather than
> privileges to the objects in question).
>
> A bonus would be a tool that could reverse engineer raw SQL queries
> and produce GUI representations ala TOAD's SQL Modeler extension (TOAD
> itself can't convert raw SQL into a query model, but evidently other
> tools can).
>
> Thanks very much.
>
> Dana

I have to ask why you haven't considered upgrading to a recent release of TOAD, as I have 9.7.2.5 and it's quite a nice tool and plays well with all releases of Oracle from 8.1.7.4 onwards. Changes in the data dictionary for recent Oracle releases are probably causing you grief with your 7.x release of TOAD, and versions from 6.x or earlier probably are more 'plain vanilla' in how they query the data dictionary (my guess) since you state that these older releases play nicely with the newer versions of Oracle.

Of course I'm using a corporate license so I don't see the cost of the tool, and I know, from your post, that's a consideration.

David Fitzjarrell Received on Fri May 29 2009 - 14:27:12 CEST