views:

4870

answers:

23

Hello.

I'm currently using Toad for my day-to-day work on our databases (queries, updates, small scripts, browsing of db objects, etc.).

My question is: since my version of Toad is old and buggy, which are the (possibly free, but not necessarily) alternatives to Toad?

The database versions we are using are 10g and 9i.

Thanks a lot.

A: 

PLSQL Developer very good for Oracle DBMS, specifically for Stored Proc, but not so well for the DBMS management.

+7  A: 

I've used Squirrel-SQL (which is a Java/JDBC based program and will work with any OS or database that provides a driver) and the database development tools for Eclipse (Eclipse-DTP). Both are certainly sufficient for light database work. Both are free and open-source.

Steve Moyer
+27  A: 

Oracle's SQL Developer.

johnstok
On a recent project we had a bunch of long-time TOAD users who were very attached to it. They were encouraged to use SQL Developer, and after a day they didn't look back.
Stewart Johnson
At a first glance SQL Developer doesn't seem as handy as Toad. For example:1) Toad reads connection sources directly from local tnsnames.ora, so you can connect quickly2) Toad has the nice shift-F9 (execute current group of lines) combination in the sql editorI'll stick with Toad, for now.
friol
SQL Developer reads from the tnsnames.ora too. There's a keyboard shortcut for executing the current SQL too, but I can't remember what it is. @friol -- yours is the exact same attitude the long-time TOAD users on my project had. :-)
Stewart Johnson
SQL Developer has a debugger, while TOAD requires a specific license of TOAD to get the debugger.
Brian
Oracle has also just released an early adopter version of an integrated data modelling tool for SQL Developer. Looks very promising, and also free.
David Aldridge
Ugh... I have SQL Developer and it is killing me. It takes 2 minutes to load, and gobbles up 700 MB of RAM before it is ready to run the simplest query... BAH.
Yuval
+1  A: 

I would also recommend Oracle's SQL Developer, however I've found WinSQL to be quite good as well. SQL Developer is free and WinSQL has a community version that is quite robust, and works well against other platforms too (I also use it for working with Netezza).

Jamey
+11  A: 

PL/SQL Developer from http://www.allroundautomations.nl/. Presented between a choice between Toad and PL/SQL developer, about half the developers prefer PL/SQL developer. I have to admit the code completion in PL/SQL developer is much better, but I still prefer Toad for the DBMS management functionality.

Tony BenBrahim
+1  A: 

Just to throw it out there - did you know you can grab the beta of Toad 4.1 and use that for free? The betas are always free to the public.

Brent Ozar
From the site: "The Beta requires that you are running the current commercial copy of Toad for Oracle". So that's not free.
friol
A: 

Worked with PL/SQL developer. It rocks.

Petar Repac
A: 

I've used Embarcadero DBArtisan (not free)

I thought it was good.

Nathan Koop
+1  A: 
mwilliams
A: 

I've used OraDeveloper by DevArt to connect to Oracle databases. It's nice because it plugs into Visual Studio in much the same way as the SQL Server databases can be queried through Server Explorer. It is not free, but in our case it came free with the purchase of OraDirect .Net, which is a new provider that allows Oracle to work with Microsoft's Entity Framework.

YeahStu
A: 

Having done 3 years in one job using TOAD, and now 5 years in current job using PL/SQL Developer, I would say overall TOAD is a better tool, but if you are specifically developing stored procedures in PL/SQL, PL/SQL Developer is better.

Don't forget get to set up the context sensitive help (under Help - HTML Manuals)

Colin Pickard
+1  A: 

You could also use sqltools, which some of my colleagues prefer. I never got used to it, but looks powerful.

André
A: 

I second the SQL Developer comments. FWIW, the newer versions of Toad are much more stable than the golden oldies were. I'm using Toad 9.7 and it's quite good.

JosephStyons
+2  A: 

TOra is an another good option. I used the pre GPL version for years. It's a good simple SQL tool for Oracle.

It supports schema browsing, analyse plan, limited debugging plus all the stuff you'd expect.

Mark Nold
I am **REALLY** surprised this answer has not got more votes! Tora is by far one of the best products listed here, very fast, performant, feature rich and everything…
Benoit
+3  A: 

After trying other products for some months, I'm back to Toad.
And I have to admit that (IMHO, and for the type of use that I'm doing of it): I've found no alternative to Toad.

The indispensable features that are missing in other products are:

  1. Speed. Toad is blazingly fast; SQL Developer starts to crawl if you open more than 2 or 3 connections. When you have to operate with time constraints, you really can't wait SQL Developer to open.

  2. The "open a new window until commit" functionality (a new window is opened after an insert or update statement, and you are forced to commit or rollback). Really handy to avoid pending commits.

  3. The "execute current statement" functionality (shift-F9). SQL Developer doesn't have it, or you are forced to select the query you want to execute.

friol
Toad? Fast? I'm using Toad for MySQL and it's damn slow and eats lots of memory, maybe the Oracle version is better...
azerole
+3  A: 

I'm surprised that nobody has mentioned DbVisualizer yet. Our company has been using it for a few years and everybody seems happy with it. It's powerful, runs on multiple platforms (Java-based) and supports different database systems (Oracle, DB2, MS Access etc). It has a free version; a commercial version is available if you need more features.

SamS
+1 For DbVizualizer. I use it against Oracle and it works great. The free version is good for light use and the personal edition is not much money.
Darrel
+1  A: 

I use PL/SQL Developer for running multiple queries and stored procedure development, as it's rock solid, and you can kill the process via Task Manager, and get back all your windows upon starting up again. I use TOAD for browsing, as that functionality can't be beat. But it's flaky on me, hanging, etc, although that is probably my computer.. I would buy both. I have both open now.

For accessing odd sources (OSISoft PI, JDE on AS400, 4D, Access, Excel), I use Advanced Query Tool. It's great to be able to use SQL against an Excel sheet of a proposed table, to create your DDL.

Joe K
+2  A: 

I've been using Golden from Benthic Software as a SQL*Plus replacement for a long time and love it.

http://www.benthicsoftware.com/products.htm

I like this product too. Great for quick querying and display of results. Also has a export directly to Excel (not just export to CSV but will load up Excel and load your file, great for quickly slicing dicing and graphing results of your queries). The price is right too.
David Mann
+1  A: 

I love Toad. I had to switch to Embarcadero's Rapid SQL for two months and it damn near killed me. So while I don't know of any products that are better than Toad, I can say without reservation that Rapid SQL is wholly inadequate.

JPLemme
A: 

I'm using PL/SQL Developer, which I think one of the best oracle database tools, it's lite and fast, I have one copy in my USB flash to allow me to use it in any pc(you just copy it from the program files folder and place it in the flash and it will work fine).

Also I bought OraDeveloper from DevArt three months ago, it's has some good features, but it's slower than PL/SQL Developer and require .Net framekwork. but the good thing that it has direct connection to Oracle, so you can use it from any PC without requiring Oracle client to be installed.

Another tools is EMS SQL Management Studio for Oracle, which looks nice, and have some nice features specially with import/export from other format. http://sqlmanager.net/en/products/studio/oracle

and for free one you can use AnySQL Maestro, which has support for Oracle/MySql/Sql server and offer AnySql Maestro for free http://www.sqlmaestro.com/

Mohammed Nasman
A: 

I've tried most of the tools suggested above, and found that I prefer this one over all of them (including TOAD): SQLDetective

Roqetman
+2  A: 

Simple answer:
Use Textpad or another text editor.

Explanation:

For me PL/SQL development is a process that has evolved over time. I've tried to apply continuous improvement to SQL development and it has worked out wonderfully for me. (for more on continuous improvement/Kaizen see link text)

I found PL/SQL IDE tools to be unstable.

I've had several crashes of Quest Software's TOAD as well as Quest Software's SQL Navigator (I've been using it since Version 3).
I lost work.
I tried other IDE PL/SQL tools.
These tools also crashed.
I lost work again.
I got frustrated.

I do not trust PL/SQL software development to any of the PL/SQL IDE tools out there.

Here are my PL/SQL coding core practices:
1. Export code using Quest Software TOAD
2. Use a Cygwin bash script to move files into the appropriate directories
3. Compare versions via BeyondCompare (if needed)
4. Check code out of WinCVS / CVSNT (if needed)
5. Edit using TextPad
6. Compare versions via BeyondCompare (if needed)
7. Check code in to WinCVS / CVSNT (if needed)
8. Use a Cygwin bash script to create a master changes file.
9. Import code back using Quest Software TOAD

An even more lengthy explanation:

I use Quest Software TOAD to export all PL/SQL and table DDL code to the filesystem.

In the Database menu -> Export -> Source Code
In the Database menu -> Export -> Table Scripts

This gets me individual files for each database object.

I move these files (Cygwin bash script) in directories
based on the file extensions.
*.prc files in /procedures
*.fnc files in /functions
*.pks and *.pkb files in /proceudres
*.trg files in /triggers
*.vw files in /views
*.sql files in /table_scripts

These files are initially checked into CVS.
(I use WinCVS/CVSNT server side)

I Beyond Compare each file version exported by TOAD
with the version already in CVS.
I ensure that the CVS sql repository is up to date.
In other words I need to have a good starting baseline.

I then use TextPad to edit the PL/SQL code.
link text

I pre-configure my Textpad with SQL syntax files
to make it easier on the eyes
link text

After editing, I Beyond Compare each edited
file version exported with the version
in WinCVS.

Luckily, WinCVS allows you to use an external
diff (Beyond Compare) which comes in very handy.

I load the new/changed code via TOAD to a test schema.
In the SQL Editor menu -> Load and Execute a Script File

I test the code out. (do some debug runs)

If the code tests out, I check the code into CVS.

At the end, I use Cygwin bash (and a bash script I've written) to create a master changes file. This master changes file contains all of the changes that need to be applied to bring the live schema up to date. This saves me a lot of time.

I then load the new/changed code via TOAD to a live schema. In the SQL Editor menu -> Load and Execute a Script File. That's about it. Software engineering is about process, versioning (CVS) and automating builds (bash script).

The biggest lesson out of all this (that have made me 10 times more productive) was switching from DB-based PL/SQL IDEs to simple ASCII text files. KIS in action.

If a copy your code resides in an ASCII file you avoid:
- mucking up the DB
- locking up DB objects
- iffy DB based revision control tools (if any)
- iffy DB diff tools (if any)
- losing code due to IDE crashes
- losing code due to DB crashes / shutdowns
- losing code due to concurrent editing (this can happen if two or more PL/SQL developers edit the same procedure)

Instead if you handle all PL/SQL code in filesystem ASCII files you have
- your choice of text editors (TextPad,notepad++,vi,etc)
- your choice of revision control systems (CVS,svn)
- your choice of text filtering/handling/scripting systems (I like Cygwin bash)
- your choice of diff tools (Beyond Compare,WinDiff,diff)
- your choice of DB tools (I can use TOAD, SQL Navigator) for importing and exporting the PL/SQL code to files.

I wanted a version history of all code changes.
I wanted to get everyone working together and prevent developers from stepping on each other's toes.
I wanted the freedom to choose my tools.
The side effect of this is that I handle all of the DB code in the filesystem during rapid development.

Just my 2 cents.

Dragos Toader
A: 

Check out OraDeveloper Studio, it is a rather powerful development environment for working with Oracle with a bunch of useful features.

OraDeveloper Studio supports Oracle versions 7 to 11g.

Devart