|First, I am an absolute "database-beginner"
Here is my szenario in my daily business-live:
I have a lot (~30) different datatables which I combine to produce usefull-information.
The main topics are:
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business
For the "production of usefull information" (this is reporting) I use my own proprietary C#-Programs, where I perform "the logic". Means: Filtering, Joining, Combining,.....
The final result is written into Excel-Sheets. The end-users use these excel-files for their needs
Here is my question:
Especially, step b, with my proprietary C#-Programs needs a lot of time for maintenance/updates/.... due to heavily changing environment. It is time-consuming to maintain it.
How do "professional database-engineers" handle such a task?. What is their approach? Which tools are they using?
modified 9-Nov-12 7:14am.