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
RdichpallyAsked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.