Database

Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.

Search this forum
	Profile popups Spacing Noise Layout Per page Show

First, I am an absolute "database-beginner" Smile | :)

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:
a)
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business

b)
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,.....

c)
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:14.

General News Suggestion Question Bug Answer Joke Rant Admin

		9,892,249 members (35,191 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using