TOAD vs. SQL Developer vs. what / Using TOAD 7.x against Oracle 10g server and an 11g client
From: <dana_at_work_at_yahoo.com>
Date: Fri, 29 May 2009 04:19:04 -0700 (PDT)
Message-ID: <3c7bebc9-bd8b-4d51-bd6f-ce167d909c20_at_t21g2000yqi.googlegroups.com>
[Quoted] Here's my dilemma:
Date: Fri, 29 May 2009 04:19:04 -0700 (PDT)
Message-ID: <3c7bebc9-bd8b-4d51-bd6f-ce167d909c20_at_t21g2000yqi.googlegroups.com>
[Quoted] 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:
- 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.
- 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 Received on Fri May 29 2009 - 13:19:04 CEST