Chapter 15. Managing Distributed Databases with DTS and Message Queues

Managing Distributed Databases with DTS and Message Queues

One of the new tasks in DTS for SQL Server 2000 is the Message Queue Task. This task is designed to allow DTS to participate in all design situations in which message queues are useful.

Message queuing is all about moving data between loosely coupled, highly distributed applications and systems. Message queuing has an infrastructure in many ways similar to email systems, but instead of sending mail to people, you send messages to queues. Instead of people looking in their inboxes for mail, applications monitor a queue. When a message arrives, the application can open the message ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.