The tool for Oracle
Overall Satisfaction with Toad for Oracle
Toad is the best tool for SQL development, you can have thousands of tables and the indexation and current searches work fantastic, if I had to describe it in one word it should be fast.
Pros
- Import/Export function where we are able to export the data in any of the format like .csv, xlsx, .txt etc., according to the number of rows required.
- Database diagram - Easily able to generate the database diagram which will shows the relationship between objects.
- Toad automation scripts and formatting SQL scripts for developer.
- Transform function and cleansing the data.
Cons
- License Key is costly since we have to pay rather than open-ended tool.
- Some of the SQL commands are still not recognized by Toad like (NOSQL), PIVOT etc.
- Reporting will not be exact since this is not owned by database production. An example of that is SSRS reports run by Microsoft.
- Some of the data sources I connect to are very primitive and still use pipe-delimited flat files. I have figured out a way to connect to these but it was very difficult.
- I wish it were easier to convert Oracle to SQL Server, SQL scripting and vise versa. I move frequently between the two and tire of rewriting my scripts.
- I've had some preferences lost in the course of an upgrade. We have a very specific network and operating system environment with roaming profiles, so that could simply be a result of that.
Comments
Please log in to join the conversation