| ChrisR 2006-02-17, 7:23 am |
| I have used built in SQL replication to replicate data at a few companies. I
think its a great solution.
"Sean Aitken" wrote:
> Good afternoon,
>
> Lately there has been discussion of what the best practice would be for
> enterprise reporting needs. Specifically, we currently have online OLTP
> servers for our business apps, as well as a data warehouse server.
>
> A member of our team has suggested that we create a new server farm (or
> server) for real time reporting to alleviate the real time reporting
> burden off the production servers.
>
> I was looking for any advice or pointers to design a topology that can
> support our current real time systems as well as data warehousing
> needs, while still minimizing the burden of reporting against our live
> production servers.
>
> The mention of replication has come to mind, but I'm not completely
> sold on attempting to replicate our production data for the "heck of
> it"...
>
> Any thoughts?
>
> Best regards,
> -Sean
>
>
|