We have a requirement here. Whenever certain rows in a table are inserted, updated or deleted, we need to send messages to a message broker for further processing. Currently we are using triggers and SQL Server Service Broker for this purpose. But we want to use RabbitMQ for scalability and wider reach. Is there a third party solution component available to meet our requirements. We are ready to implement ourselves if 3rd party component is not available.
I have not tried any of this:
Do we have any other 3rd party components which specifically meets the requirement.
Not that I am aware of. We use some Service Broker and at one stage were looking at the possibility of RabbitMQ but did not proceed. Using the CLR was the best option I could find.