If you were talking to someone whose organization is considering Toad Data Modeler, what would you say?
How would you rate it and why? Any other tips or advice?
I have not used the SQL Server version a great deal, but I can say that when I used it with Oracle and comparing it to the Oracle Management Studio, Toad was by far the best. For Oracle developers, this solution is a must. I don't think it is such a big jump from the SQL Management Studio, but from the Oracle point of view, it's a brilliant piece of software that makes things so much easier. It includes triggers or exits with remote debugging, and you have execution plans, all of which are helpful. This is a very good product, but it is a little bit expensive. I would rate this solution a nine out of ten.
This is a program that I like very much and I recommend for others. I would rate this solution a ten out of ten.
Toad is fast and very convenient. You just need to choose what you want to create, configure all the items and objects, then just generate the scripts, test and you can use the same script and create the objects in production. It is an easy tool to use. Toad is a tool to efficiently connect to and use the Oracle database. It gives you the power so you can query, develop the keys and you can execute them to store and retrieve the data. However, when you use a larger database, you may not end up with the only single database type. For example, you might have another system where you had big data or something so in that case, you are better off to choose some free database management system — a generic database system like Postgres or MySQL. Oracle is comparatively not cost-effective. It is the best, but having the best comes with a cost. So when you use Oracle as your database you know you are using a good product. If your system is more complicated, Toad may not be able to connect to all the databases available. We use DBeaver in that case which is fourth-generation and the fifth-generation database tool and allows you to connect to all kind of databases like MySQL, SQLserver, Postgres, or other tools. For our purposes, Toad is a single tool which helps you connect to Oracle. In our experience, sometimes a business is more interested in such kind of tool that they know by name and can trust. Toad is best obviously, they use it, but sometimes it is confused with a lot of different tools whose purpose is not the same. Most of the users who are using Toad have got a contract with Toad. For those who do not, it can be a hefty cost to move to Toad. Once they know that there is extra involved, then they will not have as much interest if what they are doing is not within its scope. You can use for Oracle only and has some higher-end limitations, but if someone is already extensively using Toad's database then they might face these kinds of costs. All that said, I would rate Toad a ten out of ten compared to other products with use for Oracle. We know what it is we can use it for and it is always the best product for the purpose. Until now, ur servers have always worked.
I don't work with Toad, I support Toad because I work in a distributor company. I deal mostly with the on-premises version of the solution. I would recommend Toad but I think it would be a better solution if it had one platform or if it was an all-in-one tool. I would rate this solution nine out of ten. I'd rate it higher, but right now, for example, if I want to work with the database I must load Toad for Oracle or Toad for MySQL, etc. But if I want to work with the Toad Modeler, I don't want another Toad installation. If there was a one-stop solution, it would be a ten.
Managing such huge volumes of data has become very efficient.