BizTalk Legacy SQL Adapter was announced deprecated long ago and was removed from the CD image in BizTalk Server 2020 release. Many of our customers who are now moving to 2020 release, find an additional work item to upgrade to using WCF-SQL Adapter in place of Legacy SQL.
While we continue the deprecated state of this adapter and offer no support in production scenarios in 2020 environment, here is a relief to customers to plan their migration efforts better. You can download the LegacySQLAdapter msi from here.
Please Note:
If user community runs into any issues, we will discuss them in the comment section of this post and update the steps here as necessary. Please remember this to be just an aid for migration and upgrade to 2020 and we totally depend upon the community to constructively collaborate.
Some of the code that BizTalk manages, was updated in 2020 release to use WCF-SQL Adapter instead of Legacy SQL (For example EDI Receive Locations, ESBT Send Ports and such). We must leave these changes in place. Any attempt to change that part of code to work with legacy SQL will break BizTalk and must not be attempted.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.