November 12, 2013 at 7:46 am
Hi,
I'm looking for general advice/best practices/experiences on replicating production data to a reporting server. I ask as my company has attempted the process once before, but abandoned the process as the data transfer took several hours.
I would appreciate anything shared on this topic
November 13, 2013 at 2:42 pm
bjesmith2 (11/12/2013)
I'm looking for general advice/best practices/experiences on replicating production data to a reporting server. I ask as my company has attempted the process once before, but abandoned the process as the data transfer took several hours.
Lots of questions here. Are you looking at creating a data warehouse? or are you just looking at another copy of your OLTP data?
Are you trying to improve performance by moving your operational reports from the production system to a secondary copy?
What type of timing requirements are there for the reports? Do they need to be real time? or if the data is a day old is that good enough?
The answers to those broad questions will tell how to proceed.
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply