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 |
|
jaypee_s
Starting Member
22 Posts |
 Posted - 2008-04-24 : 01:50:30
|
| I have two database, one is for production and another for reporting database, in this Scenario we need to transfer the real time data to reporting database, which replication we need to use and what at the bottelnecks in this..can any one give some suggesstions or give some links...Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-24 : 02:21:37
|
| Transactional replicationTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jaypee_s
Starting Member
22 Posts |
Posted - 2008-04-24 : 02:28:21
|
| IS performance issue will araise, if so how to solve this.... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-24 : 15:59:34
|
| Read performance improvements for transactional replication in Books Online. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-24 : 21:35:44
|
| Keep in mind that sql2k5 express can't be publisher of transactional replication, since you posted in sql2k5 express forum. |
|
|
|
|
|
|
Real time replication