PrimalScript 2007 Enterprise includes a new feature: Visual Query Builder. You may have seen something like this before in SQL Server or Microsoft Access. With Visual Query Builder you drag and drop tables, connect them and fill in some blanks to produce a SQL statement. You don’t have to write a complex SQL query off the top of your head. Grab the tables you want, add the associations and the query is built for you. The Visual Query Builder works with any ODBC or OLE DB data source.
You can run the query directly in the Visual Query Builder so you know immediately if you are getting the results you need or if you need to tweak the query further.
Because the Visual Query Builder is working with a live database, if you write an Update or Insert query, you can modify the database directly. No scripting required. Although, you can tell the Visual Query Builder to convert your query into VBScript which you can then paste into a script file. You can grab the connection string from the query properties to paste into your script. The Visual Query Builder doesn’t generate VBScript code like the ADO Wizard but is great for creating complex queries that you can test immediately with live data.
You can save the query so you can open it later. The Visual Query Builder also lets you save metadata to an XML file. With this metadata, you can work with your query offline. You won’t have access to live data, but you’ll have database and table information.
If you are an experienced database administrator you’ll also find many advanced settings under Query Builder properties.
The Visual Query Builder is an enterprise answer to an enterprise need for today’s Windows administrators. We hope you’ll download an evaluation copy and see for yourself.
