SQL Builders
Likes 0
Link | FlySpeed SQL Query | Data Xtractor | Valentina Studio | dbForge | Aqua Data Studio | Navicat for SQL | DBSchema | Heidi SQL | EMS Advanced Query Build | Active Query Builder | SQLeo Visual Query Builder |
---|---|---|---|---|---|---|---|---|---|---|---|
Pro's | Seems to do just what I need right out of the box and it's free. Seems logical and easy to use. Easy decision in favour | Fairly easy to use and does most things one needs. I already own it | Seems clear and simple, if perhaps lacking in sophistication as a result. Nice clear layout of the diagram. Simplest version is FREE (but SAVE is disabled - which meant than when my sql query went into some kind of loop and I had to abort, all my work was lost). Easy view of the child/parent table relationships. Easy to select tables using search box if you know the table name. Select Fields are selected using drag-n-drop which has the advantage that it's then easy to create the order in which you wish to see the data but the disadvantage that it the process can be slightly hit and miss especially on a small screen on remote desktop. There are several extra data analysis tools built in which makes it nice but probably these are not necessary for my purposes. | One-click diagram organiser. Easy to create aliases Seems to sometimes allow building of diagram from SQL. All layout changes are saved when you close the application and restored when you open it again. You can use the Query Profiler tool to debug, troubleshoot, monitor, and measure your application's SQL statements and stored procedures. If your application has a performance problem that you think might be caused by a particularly long-running query, you can analyze query durations. | Easy saving of favourite tables, saves wading through long lists. Easy to use and read table joins. | ||||||
Con's | Only negative I came across so far is that it's not easy to manually link tables that are not visible on the diagram but that might be my ignorance | seems to leave the 'dbo.' in at the start of the table name | Difficult to figure out how to trial and no free trial of pro version. Cannot save query in free version. | Does not seem to have a Visual Query Builder | Does not automatically link tables | ||||||
Best used | |||||||||||
Usage example | |||||||||||
Known Shortcomings | |||||||||||
Main focus | |||||||||||
License | |||||||||||
Pricing | |||||||||||
Projects using it | |||||||||||
Technical details | |||||||||||
Latest version | |||||||||||
Release date | |||||||||||
Initial release | |||||||||||
Consistency | |||||||||||
Replication | |||||||||||
Protocol | |||||||||||
Data Presentation | |||||||||||
Development language | |||||||||||
Platforms | |||||||||||
API Language | |||||||||||
Embedded Language | |||||||||||
Additional | |||||||||||
Website | |||||||||||
Wikipedia | |||||||||||
Additional link | |||||||||||
Features | |||||||||||
Cloud DB | |||||||||||
Transaction support | |||||||||||
Domain-model Aggregation | |||||||||||
GeoSpatial | |||||||||||
FullText | |||||||||||
Commercial Support |
User reviews and comments