Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spfeiffer13
Starting Member
1 Post |
 Posted - 2007-02-06 : 15:47:51
|
| I am working with several SQL DB's both in-house and hosted out-of-house. I need to create reporting across these DB's (5 DB's). Can anyone point me in the right direction to approach this. I'm not a newbie at SQL but definitely not an expert yet. My supervisor asked me to look at data warehousing. Another suggestion was to setup an in-house DB that replicates the data of all of the other DB's. That seems a little repetitive to me. We also need to come up with a way to archive data on a yearly basis so that our applications don't get bogged down. But, we still need to be able to run reports off of the old data. Some reports may need to run against both old data (archived) and new data.I apologize if this is in the wrong category.Thank you in advance for any input!Scott |
|
|
|
|
|
Data Warehouseing and cross DB reporting