This is an old revision of the document!
Table of Contents
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.
My notes
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 “active”, to satisfy the needs of users without great knowledge of technology and focused in getting results instead of getting an sql made.
http://www.activequerybuilder.com
Webpage: http://www.activequerybuilder.com/download.html 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://www.basenow.com
Webpage: http://www.basenow.com Price:
My Impression
Easy installation. All the application in english, not good.
Professional appearance.
Doesn't work with big databases. I am testing the application with an Oracle database of 125 tables and takes years just to open the list of available tables.
Products I am evaluating
http://sourceforge.net/projects/qbevisual/
http://sourceforge.net/projects/sqlmaster/files/
http://sourceforge.net/projects/myquerybuilder/
http://sourceforge.net/projects/vsqlbuilder/
http://sourceforge.net/projects/sqleonardo/
http://www.originlab.com/index.aspx?go=Products/Origin/ImportingData/DatabaseAccess
http://www.sqlquerybuilder.com
Curious:
And the winner is...
No winner yet.