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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-04 : 01:30:35
|
| Dear All,what is the exact difference between the replications transactional and transactional with update subscriptions.....and need one more clarification....push subscription is burden for production server?actually my doubt is instead of push subscription, why not i use pull subscription? so that the resources of replication server will be utilized instead of production server. am i correct?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-04 : 06:38:35
|
| i'm not getting any help for this post....ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 08:25:15
|
| Transactional replication with update subscription is 2-way replication and has triggers like Merge Replication. We always do Pull subscription for replication. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 08:28:01
|
| Also ,why are you posting replications questions here? You should post in Replication SQL 2005. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-05 : 02:52:00
|
| Thank you sodeep, so this means with Transactional replication with update subscription, if we change some thing at subscriber, at publisher that will reflect....am i correct?and this is most fast answers forum than replication forum as per my observation. so i've posted here. i'l post there from now.thank youArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
transactional replication and update subscriptions