RabbitMQ via SQL Server

• TryingToLearn

  SSCrazy

  Points: 2646

  More actions

  October 25, 2016 at 10:04 am

  #318370

  i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?

  We already use RabbitMQ processing queues on the Oracle side and now we are finding it would helpful to get some SQL notifications in the same manner.

  Before i begin testing this i was hoping to go in the proper directions.

  Thanks.

• Jeff Moden

  SSC Guru

  Points: 1004403

  More actions

  October 25, 2016 at 11:14 pm

  #1908800

  TryingToLearn (10/25/2016)

  ---

  i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?

  We already use RabbitMQ processing queues on the Oracle side and now we are finding it would helpful to get some SQL notifications in the same manner.

  Before i begin testing this i was hoping to go in the proper directions.

  Thanks.

  You might be looking for "Service Broker" in SQL Server. Never heard of MSMQ before.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Eirikur Eiriksson

  SSC Guru

  Points: 182915

  More actions

  October 26, 2016 at 4:12 am

  #1908831

  Jeff Moden (10/25/2016)

  ---

  TryingToLearn (10/25/2016)

  ---

  i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?

  We already use RabbitMQ processing queues on the Oracle side and now we are finding it would helpful to get some SQL notifications in the same manner.

  Before i begin testing this i was hoping to go in the proper directions.

  Thanks.

  You might be looking for "Service Broker" in SQL Server. Never heard of MSMQ before.

  Details on MSMQ here (Message Queuing (MSMQ))

  😎