• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

Creating an OLAP database from OLTP

Hi,

I have an OLTP database and would like to convert that into a OLAP database for reporting purposes. How do I design the database for OLAP and what tools do I need for creating the star schema with facts and dimensions tables.

What steps do I need to follow? Any help is approciated. Thanks.\

Rajender
0
Rdichpally
Asked:
Rdichpally
1 Solution
 
dbaSQLCommented:
That's a big one, sort of.  This is an older document, but it is still very applicable.
http://msdn.microsoft.com/en-us/library/aa933151.aspx

Very roughly, I would restore a backup of your current database, or create a new one entirely, rather than convert.  That way you've always got a fall back, or something to reference as you are building your new OLAP repository.
0
 
lcohanDatabase AnalystCommented:
"OLTP database and would like to convert that into a OLAP database for reporting purposes"

In my opinion that is not quite OK as you will need a OLTP database to collect your on line transactions and another OLAP database to host the analytical data only.

Also, did you considered just using SSRS maybe against your OLTP database instead "... for reporting purposes"?
0
 
RdichpallyAuthor Commented:
Thanks.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now