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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Data Replication for Report Environment

Author  Topic 

d3ng
Yak Posting Veteran

83 Posts

Posted - 2009-03-05 : 16:04:51
Hi experts,

I am a bit ignorant on which technology to use on how to replicate data in real time to separate the report environment of our system which we our currently developing. Our previous system the transactions and report is in one environment which causes us a lots of problem in terms of system hanging. Badly needed for your help! Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-05 : 17:13:41
I would use transactional replication. That's what we use here for our reporting needs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

d3ng
Yak Posting Veteran

83 Posts

Posted - 2009-03-05 : 20:37:04
Thanks. I am currently reading regarding the Transactional Replication, but out of curiosity, does data warehousing or Database Mirroring can help my concerns..? Or totally no relations at all..?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-06 : 00:32:02
Those technologies are not used for reporting. Database mirroring is a disaster recovery solution. Data Warehousing is sort of like reporting except it's a bit different. Data warehousing is a big topic, so be sure to read up on that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -