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 |
|
SSRS_Developer
Starting Member
4 Posts |
 Posted - 2009-02-16 : 17:54:34
|
| Hello, I use SQL Server 2005 and SSRS reporting tool. I am struggling to find the best way to retrive a few columns(StatsSummary columns ) from the OLTP DB for my reports created in SSRS.There is a datawarehouse but the StatsSummary tables are not populated in the dw. 1) The documentation gives 2 options. First is I can use a "logical view" to bring the tables in OLTP DB to the Datawarehouse (dw). Is logical view the same as a view? I dobut this. If not, what is a logical view? How do I use it to get what I want? 2) Secondly, it says I can use "replication" to get data from OLTP into the dw.. Will transactional replication cause the tables to lock? Will this not help with the daily reports as the replication also has to be run as a daily job. How do I over come this? 3) I was also recommended to create synonyms for the tables in OLTP and use them in the dw for the reporting. Since this is just a reference will this work for reporting? how current will the data be? Thanks in advance!!! __.____._ |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 20:05:58
|
| We use transactional replication for our reporting needs. It works efficiently. |
 |
|
|
|
|
|
How do I use columns from the OLTP DB for repotin