SQLBatch is an ADO-based SQL Query Execution tool that runs queries in batch mode using an XML file as input and generates CSV, XML or a display as output. While it was designed for Pervasive.SQL, it also works for MSSQL, MySQL, PostgreSQL, and probably a few others.

It's great for automating your database maintenance functions. The idea of SQLBatch is that it can be used to run regular maintenance-type queries from a Command file or from shortcuts.

For instance, we use SQLBatch in-house to quickly and easily generate XML feed files from our MySQL products table on our ecommerce site to update our shopping.com inventory and CSV feed files to update our Nextag.com inventory, rather than having to execute a query through phpMyAdmin and export to XML or CSV, then cut-and-paste the output to an editor to remove the spurious headers, and so on.

Included in the zip archive for SQLBatch are an annotated XML-format query input file (readme.xml) for documentation purposes, and a sample default query input file all set to run a simple query on the Pervasive.SQL Demodata database, which you can use for testing and learning.

This product is a download of a free 30-day evaluation. When you decide that SQLBatch is indispensable to you and that you want to register to continue to use it, you can use this link to SQLBatch Query Tool to purchase a serial number.