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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.