aspose file tools*
The moose likes JDBC and the fly likes Does using TOAD in this scenario make any sense? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Does using TOAD in this scenario make any sense?" Watch "Does using TOAD in this scenario make any sense?" New topic
Author

Does using TOAD in this scenario make any sense?

Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Hi All,

I am working on RAD 7.0 IDE and in the Data Perspective, I can open a new connection to the database and open the SQL scrapbook and write my queries. Now, Using TOAD when I have this feature in RAD IDE, does it make any sense? What would be the benefits of using TOAD in this scenario?

Thanks.


Be Humble... Be Nice.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

What is stopping you to have both If it is costing or licening then definetly I would suggest to do you task in RAD7 however I can bet that RAD will not offer the feature what Toad can offer you.

In my opinion both have different purpose, toad is dedicated to database operations, query optimizations etc, and if you have DBA previllege then thte limits gets extended. and the RAD is moreover meant for development and offereing its integration with app server etc.

Using totally depends on how far you want to dataabse feature.. I love using toad, but I prefer workig on SQL Plus.

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Thanks Shailesh for replying. Could you tell me some things I can do with TOAD which I cannot do using RAD's SQL Scrapbook? I have this vista OS and looks like I cannot install toad on it or can I? I want to connect to Oracle 10g database and I am using windows vista.

Thanks.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

Arjun,
TOAD is more powerful when it comes to stored procedures and the like. Coming up with a list of such things isn't as useful to you though. What really matters is what you would use TOAD for and how RAD performs at that. Also, note that Oracle's SQL Developer is free.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Um... so, what you would use TOAD for and how RAD performs at that?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

Arjun,
I don't use TOAD. I use SQL Developer (which is free.) I use that for viewing tables, keys, indexes, running queries, inserting/updating/deleting data and viewing the explain plan. I never tried using RAD for this since SQL Developer does it so well. RAD is good at getting the database schema to generate EJBs.

If I was writing stored procedures, I would use TOAD for that. I'm sure there are other things that TOAD is better than SQL Developer for, but I haven't run into those limitations yet.

You got me curious though so I did a bit of searching. This blog entry does some comparison.
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Originally posted by Jeanne Boyarsky:
RAD is good at getting the database schema to generate EJBs.


Thanks for replyin Jeanne. I am just wondering, when ya were sayin EJBs... ya were mentionin Entity Beans right?

Thanks.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

Originally posted by Arjun Reddy:
ya were mentionin Entity Beans right?

Yes. I think you can generate JPA entities too, but I haven't tried that yet.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Does using TOAD in this scenario make any sense?