Accessing Real Time Data 1

[EFREE]

Hope someone can help me with this.

I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure that calculates and puts these key performances in there respective tables. They then run reports the next day on all information from the previous day and back.

Is there a way to supply these tables real time??? I am familiar with replication but there is no way to get the data transformed into a easily readable format in near real time.

ALL IDEA’S GREATLY APPRESHIATED!!!!

Thanks,
Eric

 

[mrdenny]

Depending on the amount of agreget data you have and the number of transactions you have you could probably put triggers on the produciton tables which would them update the summary tables in real time.

However if this is a heavy load system then you could end up killing your performance.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com