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 the respective ODBC driver is installed and Data Source Name is setup on the particular PC the utility is being executed.
DataBase Extractor Pro Main Features:
Strict user control Enable/Disable of user buttons where applicableMultiple database instances saved to facilitate extracts from various database/tables using multiple SQL Select scriptsAbility to Date/Time stamp jump?filesAuto Error correction capability in the event field data is corrupt or actual field names are incorrectAdditional end of line characters Menu optionsSQL Resubmit on failure optionHourly Schedule optionAll Options are now saved upon exiting the applicationIntuitive responses to reflect SQL or Database Syntax ErrorsFull Support for Where Clause & String/Sub String ComparisonExtended Support for (Where, Group by, Order By Clauses and Select within Select)