Is biztalk server 2013 r2 supports Sql adapter

Question

Hai

Can any one confirm whether Biztalk server 2013 r2 supports  sql adapter.

Thanks in advance.

Answer 1

Well! Technically Yes, it is supported.

SQL Adapter is officially deprecated so it's really a more risky decision to use that. You should instead use WCF-SQL Adapter.

---

Rachit Sikroria (Microsoft Azure MVP)

Answer 2

Thanks  Rachit Sikroria,

may be it is risky using sql adapter,  but whether supported or not.

i have many small small applications and i am going for migration. so i dont want to change all adapter  from sql to WCF-sql.

so can u please confirm whether sql adapter is  supported or not.

thanks in advance.

Answer 3

To clarify there are two SQL Server Adapters that ship with BizTalk Server.  Here is the state of each:

SQL: Continues to ship with BizTalk server only to support legacy features such as EDI Batching, ESB Toolkit, the SWIFT(?) Accelerator and upgrade scenarios.  It is not supported for new development and should not be used for any new purpose.

WCF-SQL/sqlBinding: The current Adapter for SQL Server (all versions).  You must use this adapter for any new development that integrates with SQL Server.

In summary, use the WCF-SQL/sqlBinding Adapters for any operations with SQL Server.

Answer 4

Well Yes, Thats True!

Legacy SQL adapter is “deprecated” from the release of BizTalk 2009 onwards. This means from BizTalk 2009 version onwards, legacy SQL adapter was removed giving its way to WCF based WCF-SQL adapter.

So in terms of support for the legacy SQL adapter is the same criteria as the BizTalk engine i.e. till the BizTalk Server 2006 support exists legacy SQL adapter would be supported. BizTalk Server’s 2006 extended support’s end date is <date Day="12" Month="7" Year="2016">12/07/2016</date> and IMHO legacy SQL adapter’s support would also come to an end at the same date (<date Day="12" Month="7" Year="2016">12/07/2016</date>)

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=biztalk&Filter=FilterNO&wa=wsignin1.0

---

Rachit Sikroria (Microsoft Azure MVP)

Answer 5

Hi DineshNad,

We can get this information from Microsoft official site:

BizTalk Server no longer supports the SQL Adapter. We recommend you use Microsoft BizTalk Adapter for SQL Server to achieve the same functionality.

However, BizTalk Server supports the SQL Adapter with the components shipped with BizTalk Server, like EDI Control message SQL receive pipeline, or AS2 resend control message receive pipeline.

Have a good day.

Regards,

Angie

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.