Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kaushals
Starting Member
5 Posts |
 Posted - 2011-01-17 : 16:17:55
|
| Hi, I have a sql server which have almost 100 tables. I am planning to create another database for reporting purpose. I will dump data everynight from production server to reporting server but I will not dump all the data. I will run queries to get the calculated data (for example, instead of salesprice*qty, I will have a column called total) and dump those data in to the new database. I was wondering if there is any utility to run the queries automatically everynight and dump the results of queries into the new database? Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kaushals
Starting Member
5 Posts |
Posted - 2011-01-17 : 17:32:28
|
[quote]Originally posted by tkizer
Sounds like you need a data warehouse. Any experience with Analysis Services?I am virtually a newbie for sql server except writing sql to pull oe insert data. I don't have any experience with Analysis service but if that works then I will have to learn. I was planning to write c# program to pull data and dump into new database but i was looking for something built-in for sql server so I don't have to write 100's of line of code. Thanks for the reply. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-18 : 01:41:03
|
| I think you should rather learn Integration Services than Analysis Services as you need some flexibility in dumping the data to the data warehouse.How are you planning to query the warehouse data ? TSQL or MDX ?PBUH |
|
|
|
|
|
|
Copy part of the sql db to another sql db