This software automates database maintenance through parameterized SQL queries and processing, ensuring efficient and effective data management.
One of the standout features of the professional version is its ability to perform iterative SQL processing. With this feature, users can define commands beyond simple sequences of parameterized SQL tasks. Specifically, tasks of the 'Iterate' type can be configured to nominate a DBF source, which will be executed for each record of the database. The software will macro-process the text of an Iterate SQL task, replacing each DBF field reference with the corresponding value of the field, before executing the task for each record of the nominated database. The interface control for nominating a DBF source is called the Iterate File Picker.
Another feature that sets the professional version apart is its scripting extension. The software introduces a new task type called DBScript, which uses the same language as VO Scripting. This object-oriented language offers access to predefined classes and is easy to work with.
Overall, the professional version of this software offers significant added functionality and is a worthwhile investment for those who need to perform complex SQL tasks and want to take advantage of the software's full object-oriented language capabilities.
Version 2.0 Pro: N/A