I want to create a reporting DB from a
transaction DB. I want to add objects
views, indexes, etc to the reporting DB
for performance enhancements during
queries. This is where all non-real time
reporting requests would be pointed.
Weekly, Monthly, Quarterly, Yearly reports
run only against the reporting DB.
Let's say transaction DB is 2 GB.
I want no more than 1 days latiency(sp?) in
the data from trans DB to reporting DB.
I looked into Warm Standby - applying tlog
as necessary - problem; DB is read only I
could not add objects.
Any ideas, experiences?