April 6, 2010 at 12:01 pm
Hi All
I want to load data from database(Adventureworks) to Datawarehouse(AdventureworksDw) and i should also build some reports on it
Can anyone tell me the procedure how to do that. I really appreciate your help. Thank you
April 6, 2010 at 12:59 pm
Pretty much any method for moving data will work. If you're trying to practice an enterprise approach, I'd suggest building a full SQL Server Integration Services (SSIS) package and do it that way. But really, you could just do INSERT...SELECT... and get the job done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2010 at 2:30 pm
I agree with Grant, if the idea is to "practice" datawarehousing think of this data movement as a whole ETL a.k.a. Extract, Transform & Load - process.
Remember, datawarehousing has two sides... ETL side and Reporting side.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 6, 2010 at 4:08 pm
There's no set procedure to do this. You'll need to decide what you want the warehouse to look like. What scheme you'd want in there, and then use T-SQL or SSIS or some other method to transform the data.
April 6, 2010 at 4:12 pm
I think this thread is also a part of the other thread started by this OP.
http://www.sqlservercentral.com/Forums/Topic897834-147-1.aspx
Both are same question, just phrased differently.
To build your datawarehouse is more than a single day project. In order for us to be able to assist, we will need to know what you have attempted so far to do with it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 4:30 pm
talktome_nani (4/6/2010)
Hi AllI want to load data from database(Adventureworks) to Datawarehouse(AdventureworksDw) and i should also build some reports on it
Can anyone tell me the procedure how to do that. I really appreciate your help. Thank you
AdventureWorks Sample Data Warehouse
Includes a link to the AWDataWarehouseRefresh Package Sample
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply