I’ve had a need to create a bridge from the SQL transport over to the MSMQ transport. There was one issue that came up and i’m not sure if it is something that can be done through the bridge.
Everything we implement that uses sql (MSSQL) we create custom database schemas for instead of using dbo. When doing the SQL transport to MSMQ bridge, the bridge table is always created under the dbo schema. The issues is when the SQL transport sends the message over to the bridge it is sending it to the bridge table under the custom schema while the bridge is setup to listen on the dbo schema. Is there a way to specify the bridge to use a different schema?
[Schema].[database table name]
Sql Transport table
SQL Transport Bridge Table created when endpoint starts
When this code runs and routes the message to the bridge it sends the message the queue table with the schema while the bridge is listening on the dbo schema
Here is the bridge code: