January 24, 2012 at 8:57 am
Hi,
I'm in currently using Transactional Replication as a technology to copy the data from one location to another location
Starting 2005 and above, SQL Server provides Service Broker.
I've plan to use Service Broker instead of replication.
This is a good idea or not? Especially performance wise
Need advice from expert
January 24, 2012 at 11:22 am
For raw data copying I'd go with replication. For immediate data transfers with asynchronous transactions (ie: sending to an audit table on every update via trigger), or manipulated data, I'd use service broker.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2012 at 6:21 am
tq sir
January 27, 2012 at 11:26 am
Evil Kraig F (1/24/2012)
For raw data copying I'd go with replication. For immediate data transfers with asynchronous transactions (ie: sending to an audit table on every update via trigger), or manipulated data, I'd use service broker.
Agree mostly with this. I also use service broker for system alerts/emails.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply