How to post messages to RabbitMQ from SQL Server?

sql-server rabbitmq message-queue easynetq
Andrei Karcheuski picture Andrei Karcheuski · Mar 2, 2016 · Viewed 13.6k times · Source

I am creating an application for testing performance between different RabbitMQ clients.
One of them should be SQL Server.
I found out that there exists RabbitMQ component for SQL Server Integration Services (SSIS).
But seems like destination component which can send messages to an exchange is not written yet.
Any ideas how to perform that?
Should it be similar with posting messages to MSMQ?

Answer

cantSleepNow picture cantSleepNow · Mar 2, 2016

Short disclaimer: I am aware of the title of the question, but based on what you wrote in the comments (as well of course in the question itself), it seems that what you need is a RabbitMQ client that is able to send and receive many messages.

You don't need to write anything, there is RabbitMQ has this already. You can find it here, it's a java client called PerfTest (in the link there are also examples, but of course run it with --help) and (as name ever so obviously suggests) it is used for performance testing. You can define number of consumers, producers, messages, size of the messages etc. I have used it and still use it occasionally and it works great. Since you are (I'm assuming) new to RabbitMQ, just be vary how you pass the amqp uri parameter (here is the spec).

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
OR is not supported with CASE Statement in SQL Server

The OR operator in the WHEN clause of a CASE statement is not supported. How can I do this? CASE ebv.db_no WHEN 22978 OR 23218 OR 23219 THEN 'WECS 9500' ELSE 'WECS 9520' END as wecs_system

Read More