Trying to search for a more elegant/overall solution to our common/basic data export tasks
I am convinced that there must be software out there that allows me to:
- Define and persist a "setup" (definition of file format, delimiters, encoding, column names etc) from a GUI
- Run on a schedule/from command line
- Work on both Oracle and MSSql
However, I haven't found it yet... any tips?
From stackoverflow
-
what about using groovy to export the data to xml files.
see http://groovy.codehaus.org/Convert+SQL+Result+To+XML
for the gui thing, Oracle's SQL Developer can connect to Oracle, MySQL, SQL Server, MS Access and Sybase
-
The search ended in using products from http://sqlmanager.net.
They have products that covers the described needs, except that there are separate products for i.e. MSSQL and Oracle
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.