Hello SQL Programmers.
What is the big difference between distributed SQL and Service Broker? Am I
just confusing things here?
I am starting a project in SQL 2005 and basically I have regional server
and a data warehouse, customer might request reports which have data coming
from both regional servers and data warehouse. Should I use service broker o
r
distributed SQL to get the data from the regional servers? Basically I just
to run TSQL command on the regional server, there could be up to 50 regional
servers.
Please let me know.
Thank you,
Spike S.service broker can be within the same db, between dbs in a server or between
dbs in different servers. And its for asyncronous messaging.
Distirbuted transactions are synchronous.
Check out this link. Hope this helps.
http://www.c-sharpcorner.com/Longho...iceBroker02.asp|||Thank you Omnibuzz
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment