Help Adopting PL/SQL Developer

[d27111]

Hello, I know I

 

[ScottMattes]

I got my boss to buy our first 5 pack lic when I told him I'd buy my own if the company wouldn't. Then enough of us were bothering the customer about getting it, and we showed how the price difference with TOAD was so great, that he bought an unlimited lic.

If the speed and money don't sway them maybe you'll have to buy your own (or find a new job).

 

[CTzen]

I used the very same argument as Scott. I told him, that I would buy license myself. Later on my boss had a chance to see how flexible AA is with their support policy, and he bought even more licenses.

Plus, almost with each new release many of us can point to What's new/fixed list and say this is a change I requested.

 

[Marco van der Linden]

@d27111: You might want to google for some reviews like this one to sway your boss over to the 'good' side. I, for one, bought my own license and have never regretted extending my service license every year.

@CTzen: I see you have changed your signature

 

[CTzen]

@[Marco van der Linden]: yes, I did (thanks to your link) in anticipation of the 7.1 release that's upon us (right, Marco ? )

 

[RobertK]

Originally posted by d27111:
I am trying to sway my director to purchase a multi license pack of PL/SQL Developer and I need all the help I can get. They are always amazed....

umm what exactly is so hard about it ?
I mean unless you guys are "sharing" TOAD license...what's so hard about showing the cost diff whilst they're "always amazed"......

 

[bcoulam]

d27111,

Shouldn't be too hard to convince them if you're assertive and tactful enough. Here's my review of v6 on orafaq:

http://www.orafaq.com/tools/allround/plsql_developer

Of course, v7 is out, which is even better. I don't have an updated Orafaq review, but I do have a huge, objective Excel matrix that compares all the latest major tools from all the vendors, including v7 of PSD. Even with extra cost features included, PSD barely edges a win over Toad. With extra cost features removed, PSD is the hands down winner -- on simply features alone. Add the obvious cost differential and there's no comparison. I'd be happy to email you a copy if you wish.

Here are the total scores from the bottom of the spreadsheet:

Rapid SQLIn Oracl TOAD  SQL   SQL   PSD   SQL   Keep
              SQL   sight SQLD        Stn   Nav         Detec Tool
              7.4   3.0   1.0   8.6   7.0   5.1   7.0   3.4   7.1
w/a few extra cost options like debugger:
Total Score   1844  1962  1158  2525  1851  1906  2533  2225  1944
Approx Cost   00 5  ___SNIPPET___    65 94 65 0  7  8
w/no extra cost options:
Total Score   1634  1842  1138  2192  1572  1661  2533  2075  1789
Approx Cost   $?    5  ___SNIPPET___    0  4  0  0  9  9

Score Notes: (Mediocre is 1980, Awesome is 2640)

Keep in mind the matrix is geared toward PL/SQL developer tools, not Oracle DBA tools. So it ignores most of Toad's DBA features.

Also, the pricing above doesn't take into account Allround's current bulk and unlimited license pricing models, something most of the competitors couldn't touch. So you could end up paying as little as $50 or less per seat. It's an incredible value.

 

[Marco van der Linden]

Also, something which is often overlooked: support.

Being in the same timezone, whenever I contact support I always get a (useful) reply within 3 to 4 hours. So I daresay that wherever you are on the globe, you will get a reply within 24 hours. I don't think there are many software vendors who can beat that!!

 

[Philippe Maupoil]

Originally posted by bcoulam:

Shouldn't be too hard to convince them if you're assertive and tactful enough...Here's my review of v6 on orafaq: I'd be happy to email you a copy if you wish.
Here are the total scores from the bottom of the spreadsheet...

What about "Oracle sql developer", I really do not like it and we may have to switch to it. I could not find any comparison reviews on the web.

 

[bcoulam]

As you can see in my original reply, Oracle SQL Developer 1.0 is on there, with a score of 1158 (1138 two lines below was incorrect), scraping the bottom of the barrel by a huge margin. It really shouldn't even be considered for anyone but users who occasionally need to query a table or look at the contents of a package. It is not ready for serious development. I have not evaluated 1.1 yet. Even a 200 point difference in my matrix is a huge gap to cross in quality and additional features. It will be a long time before Oracle's free tool gets anywhere near the scores of TOAD or PSD.

 

[Philippe Maupoil]

Thanks for that! I missed it in your table.

 

[Graham Oakes]

Originally posted by bcoulam:
As you can see in my original reply, Oracle SQL Developer 1.0 is on there, with a score of 1158 (1138 two lines below was incorrect), scraping the bottom of the barrel by a huge margin. It really shouldn't even be considered for anyone but users who occasionally need to query a table or look at the contents of a package. It is not ready for serious development. I have not evaluated 1.1 yet.

At last someone calling it for what it is! I'm sick of everyone on the forums talking it up. It stinks! The only advantage it has is that it's free, but I'd rather buy my own copy of PLSQL Dev then use that pile of rubbish. BTW I've downloaded and tried out 1.1 and although it's a massive improvement over 1 it still stinks, it might make 1300 on your ratings now

 

[Marco van der Linden]

The one thing I can think of in favour of Oracle's SQL Developer is that you don't need an Oracle Client install to use it. But that's about it I guess...

 

[bcoulam]

I've recently finalized and sort of published my full matrix to http://www.dbartisans.com/oracle/docs/PLSQL_IDE_comparison.xls

In case you want to do your own evals, I've also added an empty version of the matrix (with one column of PSD's scores as both a baseline, and an example from which one can copy the necessary Excel formulas to generate the scores in each category). It is at http://www.dbartisans.com/oracle/docs/PLSQL_IDE_comparison.xlt

Pay no attention to the web site itself. It's my pipe dream for having my own DB consulting company someday.

In case it looks familiar, it is the "mother" doc behind on older copy of my matrix that is on OraFaq. He recently updated the HTML version of the same matrix using the tools he has had evaluated on his site: http://www.orafaq.com/tools/comparison

Cheers.

Check out the score for PL/SQL Developer. The clear winner!

bc

 

[Marco Kalter]

Check out the score for PL/SQL Developer. The clear winner!