projects:querybuilder
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
projects:querybuilder [2011/06/01 09:34] – [http://www.querytool.com] rlunaro | projects:querybuilder [2022/12/02 21:02] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Query builder tool ====== | ||
+ | |||
+ | ===== The project ===== | ||
+ | |||
+ | The objective is to replace the query designer of access with a similar tool. This is because access have known liminations with the size of the MDB files that make it inadequate for running enteprise-size or huge databases. | ||
+ | |||
+ | ===== Conclusions ===== | ||
+ | |||
+ | I have to conclude that there is no winner at all. The tool I was searching need to allow the migration of data between databases, permit to connect with existing Access databases and allow to store the results of a query in a new table. | ||
+ | |||
+ | This last point, the storing of the data in a new query, where the most disapointing, | ||
+ | |||
+ | Solutions??? | ||
+ | |||
+ | * Power Center | ||
+ | * Data Stage | ||
+ | * [[http:// | ||
+ | |||
+ | |||
+ | ===== Proceedings ===== | ||
+ | |||
+ | To find out what whould be the correct tools, I've search in codeplex, google and sourceforge for the most suitable products. And in the next section I've put those that more or less appear to be " | ||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** 360$ per licence. Discounts for big quantities. | ||
+ | |||
+ | Does it connect to Oracle and Access?? | ||
+ | How good is the query tool? | ||
+ | Does the query tool allow to export the query as sql? | ||
+ | Supports the creation of batch jobs?? | ||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** starting from 49$, profesional edition 99$ | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | Easy installation. All the application in english, not good. | ||
+ | |||
+ | Professional appearance. | ||
+ | |||
+ | Doesn' | ||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** 40$ | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | Easy installer. Auto-updater available, you can forget about the hassle of checking for updates from time to time. | ||
+ | |||
+ | Professional appearance. | ||
+ | |||
+ | Doesn' | ||
+ | |||
+ | Everytime I try to open a table it fails. | ||
+ | |||
+ | The trial version is only for 1 day. | ||
+ | |||
+ | ==== FlySpeed SQL Query ==== | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** 22euros | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | Very fast installation. | ||
+ | |||
+ | Quickly connection to big databases, with a feature to filter databases. It took the list of tables in a glimpse. And it refreshes the list while allows operation of the application. | ||
+ | |||
+ | It has an option to set the database as read only, an interesting feature that could avoid those nasty problems I got with other software when they try to open the tables for modify. | ||
+ | |||
+ | It doesn' | ||
+ | |||
+ | It doesn' | ||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** 180 euros | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | I were unable to connect to the oracle database. Probably a bad design in the connection interface make it difficult to achieve. | ||
+ | |||
+ | Location of tables very quickly, you don't have to wait until the list is filled. | ||
+ | |||
+ | Can't save the sql into a text file, and cannot store the result table into a new table (for make further queries). | ||
+ | |||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** free | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | It's a java application that uses the power of JDBC to connect to many databases and ease the creation of queries. | ||
+ | |||
+ | However, it is somewhat difficult to install -you have to install the jar file and provide access to it across the system- and you have to provide the necessary drivers for the application. | ||
+ | |||
+ | It takes some time to create a query, but finally it does the job. | ||
+ | |||
+ | It doesn' | ||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | My impression is that this program is a tool to help developers to create their own queries, and | ||
+ | doesn' | ||
+ | |||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | |||
+ | Only for mysql. It is a web application, | ||
+ | |||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** Free | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | It seems that the qurery builder tool is a bit rare, so I decided to evaluate this the last. | ||
+ | |||
+ | |||
+ | ==== http:// | ||
+ | |||
+ | * **Webpage: | ||
+ | * **Price:** Free | ||
+ | |||
+ | **My Impression** | ||
+ | |||
+ | It only works with mysql. Furthermore, | ||
+ | |||
+ | |||
+ | ===== Products I am evaluating ===== | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | http:// | ||
+ | |||
+ | |||
+ | http:// | ||
+ | |||
+ | Curious: | ||
+ | |||
+ | http:// | ||
+ | |||
+ | |||
+ | |||