Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replicating data to a BI/Reporting Server Expand / Collapse
Author
Message
Posted Tuesday, November 12, 2013 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:09 PM
Points: 5, Visits: 126
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
Post #1513464
Posted Wednesday, November 13, 2013 2:42 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:50 AM
Points: 1,234, Visits: 1,273
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
Post #1514072
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse