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.
- 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.
- 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.