This DataBase utility was engineered with automation and simplicity in mind. In this demanding business world ever rapidly changing, requires us to constantly upgrade and optimise infrastructure.
This ultimately leads to the need to migrate information(data) onto newer high tech platforms. This until now required aquisitioning of external resources with specialised skillsets to get the Job Done.
Happily now this can be afforded to anyone with basic SQL skills. The utility inteprets the query and automatically populates a file with all the fields requested.
Simply and Effectively, regardless of the SQL database. Once an ODBC driver is setup on the particular PC the utility is being executed. Some of the key Features are : Connecting to any SQL Compliant Server & DataBase Scheduling Capability FTP Upload Capability Friendly Error Trapping Script Analyser Ability to Interpret SQL and populate a file Based on the fields stated in the SQL Statement Error Correction of Field selection in SQL statement Strict user control Enable/Disable of user buttons where applicable Multiple database instances saved to facilitate extracts from various database/tables using multiple SQL Select scripts Ability to Date/Time stamp dump files Auto Error correction capability in the event field data is corrupt or actual field names are incorrect Additional end of line characters Menu options.