Click here to Skip to main content
       

Database

 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database PinmemberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pinmemberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database PinmemberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database PinmemberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 0:52 
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:14am.

AnswerRe: How to create reports effectively PinmemberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively PinmemberMycroft Holmes9-Nov-12 4:08 
AnswerRe: How to create reports effectively PinmemberFrygreen9-Nov-12 4:10 
Suggestionsql server 2008 security PinmemberMember 36227527-Nov-12 8:00 
GeneralRe: sql server 2008 security PinmemberMycroft Holmes7-Nov-12 11:27 
GeneralRe: sql server 2008 security Pinmemberjschell8-Nov-12 8:56 
QuestionHelp me my Sql expired Pinmembermehdi_nassiri00986-Nov-12 10:03 
AnswerRe: Help me my Sql expired PinmemberJörgen Andersson6-Nov-12 10:22 
AnswerRe: Help me my Sql expired PinmemberJoy Sinha22-Nov-12 20:09 
QuestionADO.NET PinmemberM.T.H.Danish6-Nov-12 6:25 
AnswerRe: ADO.NET PinmvpRichard MacCutchan6-Nov-12 7:28 
AnswerRe: ADO.NET PinmemberEddy Vluggen6-Nov-12 9:18 
GeneralADO.NET PinmemberM.T.H.Danish6-Nov-12 6:11 
AnswerRe: ADO.NET Pinmemberihoecken6-Nov-12 6:27 
QuestionSQL SERVER 2008 PinmemberM.T.H.Danish6-Nov-12 2:49 
AnswerRe: SQL SERVER 2008 PinmemberDavid Mujica6-Nov-12 3:27 
AnswerRe: SQL SERVER 2008 PinmemberJ4amieC6-Nov-12 3:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140921.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid