data warehouse

• erics44

  SSCertifiable

  Points: 6150

  More actions

  September 4, 2012 at 12:49 am

  #261030

  i have a data warehouse question for you, I have a set of reports that I am migrating to a sql server 2008 from mysql.

  I have created a couple of views that all of the reports are based on and now i want to create some sort of data warehouse based on these views.

  Everything is currently in 1 database as in the general operations of the database and the reporting.

  i am considering a new database for the reporting and maybe running some ssis packages to move any updated data into there.

  Is there a better way of keeping the data upto date in a separate database? (mirroring, log shipping, replecation)

  these views are currently slower than they could be if i created a different view per report but then obviously maintenance would be a lot more difficult and report production slower. at the minute with these views report production is very fast and i know i can fully rely on the data in each one as the queries are tried and tested.

  I suppose the basis for my questions is that i want reporting in it's own space because i need a way of speeding the reporting up and at the same time keeping these denormalised views/tables.

  I am going to explore ssas too