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?
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.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Nov 10, 2007
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.
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, 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.
Joined: Nov 10, 2007
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?