Reporting Database Considerations We have a very large database that we want to write almost real time. We want to take data and move it to another instance of the database on top of which will be a GUI and MI tool which will be able to report on the data.

I've got the following so far - does anybody else have any considerations I should bear in mind when spec'ing this:


Data Migration / Retention Period / Legal Requirements of Storage 
Tables / Fields that need to be available in reporting database 
Permissioning / User Access 
Key fields that need to be queried 
Disaster Recovery Requirements 
Replication Timing
I think what you're looking for is, "What are all the things I need to keep in mind when designing a data warehouse?"

There's a lot of good resources out there on it:


https://www.cu.edu/irm/stds/ddg/dzproces.html
http://www.slideshare.net/markginnebaugh/architecting-a-data-warehouse-a-case-study
http://msdn.microsoft.com/en-us/library/aa902672%28SQL.80%29.aspx