When comparing Toad vs SQLGate, the Slant community recommends Toad for most people. In the question“What are the best SQL Clients for Windows?” Toad is ranked 7th while SQLGate is ranked 8th. The most important reason people chose Toad is:
Toad is maintained by Dell and has great community support.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Reliable
Toad is maintained by Dell and has great community support.
Pro Free
Toad is free to use.
Pro Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Pro Saves time with autocomplete & template functions
Pro Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
Pro Supports cloud-based DB such as AWS & Azure
Pro Includes PL/SQL editor and debugger
Pro ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
Cons
Con Fewer features
Still some more features are required to add. Other than that its perfectly fine.
Con No built-in SSH tunneling
Toad currently doesn't provide built-in SSH tunneling.
Con Logon
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
Con Free version is limited
e.g. only 10 tables allowed in ERD designer.
