• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Does using TOAD in this scenario make any sense?

 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34686
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Um... so, what you would use TOAD for and how RAD performs at that?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34686
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34686
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic