Manually configure a physical port binding to the SQL adapter

This section provides information about configuring the Microsoft BizTalk Adapter for SQL Server as a WCF custom binding or as a WCF-SQL port by using the BizTalk Server Administration console. After deploying the adapter, you will be able to send and receive messages from SQL Server by using the BizTalk Server Administration console. The steps for deploying the adapter vary depending on:

• The direction of communication between BizTalk Server and the SQL adapter. You may choose to configure a send, receive, or a send-receive port. Your choices are summarized in the following table.

  Port direction	Communication pattern	Direction of communication to choose from
  Send	One-way	I will always be sending messages on this port.
  Receive	One-way	I will always be receiving messages on this port.
  Send-receive	Request-response	I will be sending a request and receiving a response.

  Note

  Two-way receive ports are not supported by the SQL adapter.

  For more information, see How to Create a Send Port, or How to Create a Receive Port.

• Whether the adapter sends messages to the SQL Server (outbound operations) or receives messages from SQL Server (inbound operations). Depending on whether you want to send or receive messages, you will create a send or receive port, respectively.

  Note

  You can also configure the send or receive ports by importing a binding configuration file that is created by the Consume Adapter Service Add-in as part of metadata generation. For instructions on configuring ports using this binding file, see Configure a physical port binding using a port binding file to use the SQL adapter.

In This Section

• Configure a port using the WCF-custom adapter and SQL adapter

• Configure a port using the WCF-SQL adapter

See Also

Building blocks to develop BizTalk applications with the SQL adapter