%3CLINGO-SUB%20id%3D%22lingo-sub-1407055%22%20slang%3D%22en-US%22%3ELegacy%20SQL%20Adapter%20(Deprecated)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1407055%22%20slang%3D%22en-US%22%3E%3CP%3EBizTalk%20Legacy%20SQL%20Adapter%20was%20announced%20deprecated%20long%20ago%20and%20was%20removed%20from%20the%20CD%20image%20in%20BizTalk%20Server%202020%20release.%20Many%20of%20our%20customers%20who%20are%20now%20moving%20to%202020%20release%2C%20find%20an%20additional%20work%20item%20to%20upgrade%20to%20using%20WCF-SQL%20Adapter%20in%20place%20of%20Legacy%20SQL.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhile%20we%20continue%20the%20deprecated%20state%20of%20this%20adapter%20and%20offer%20no%20support%20in%20production%20scenarios%20in%202020%20environment%2C%20here%20is%20a%20relief%20to%20customers%20to%20plan%20their%20migration%20efforts%20better.%20You%20can%20download%20the%20LegacySQLAdapter%20msi%20from%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D101313%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20Note%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EYou%20will%20need%20to%20bring%20and%20install%20the%20necessary%20pre-requisites%20on%20the%20machine.%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.microsoft.com%252Fen-us%252Fdownload%252Fdetails.aspx%253Fid%253D30403%26amp%3Bdata%3D02%257C01%257CSanjiv.Gupta%2540microsoft.com%257Cb307f19485e84febcd7208d7fc32cc58%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637255167411767023%26amp%3Bsdata%3DMnJmmliRfgJZbqQ5Wsr8F8h86ovD8T3S%252F6AXLlQaasg%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQLXML%204.0%20SP1%3C%2FA%3E%20must%20be%20installed%20from%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.microsoft.com%252Fen-us%252Fdownload%252Fdetails.aspx%253Fid%253D30403%26amp%3Bdata%3D02%257C01%257CSanjiv.Gupta%2540microsoft.com%257Cb307f19485e84febcd7208d7fc32cc58%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637255167411777024%26amp%3Bsdata%3DRtc%252Fihe4k7jt9hcBRgTgpPvChxXsjr%252Blv8YPnAAfofg%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D30403%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3EAfter%20installing%20LegacySQLAdapter%20msi%2C%20you%20must%20add%20SQL%20adapter%20in%20BizTalk%20using%20Admin%20Console.%20This%20step%20must%20be%20performed%20before%20attempting%20to%20use%20this%20adapter%20in%20receive%20locations%20and%2For%20send%20ports.%20Following%20screen%20shots%20provide%20some%20guidance%20on%20how%20to%20accomplish%20this%20task.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CDIV%20id%3D%22tinyMceEditorSanjiv380_2%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22LegacySQL1.jpg%22%20style%3D%22width%3A%20599px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193430i1BE85276F9949ECF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22LegacySQL1.jpg%22%20alt%3D%22LegacySQL1.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorSanjiv380_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22legacySQL2.jpg%22%20style%3D%22width%3A%20571px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193431i047373574D24D5C4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22legacySQL2.jpg%22%20alt%3D%22legacySQL2.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorSanjiv380_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20user%20community%20runs%20into%20any%20issues%2C%20we%20will%20discuss%20them%20in%20the%20comment%20section%20of%20this%20post%20and%20update%20the%20steps%20here%20as%20necessary.%20Please%20remember%20this%20to%20be%20just%20an%20aid%20for%20migration%20and%20upgrade%20to%202020%20and%20we%20totally%20depend%20upon%20the%20community%20to%20constructively%20collaborate.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20of%20the%20code%20that%20BizTalk%20manages%2C%20was%20updated%20in%202020%20release%20to%20use%20WCF-SQL%20Adapter%20instead%20of%20Legacy%20SQL%20(For%20example%20EDI%20Receive%20Locations%2C%20ESBT%20Send%20Ports%20and%20such).%20We%20must%20leave%20these%20changes%20in%20place.%20Any%26nbsp%3B%20attempt%20to%20change%20that%20part%20of%20code%20to%20work%20with%20legacy%20SQL%20will%20break%20BizTalk%20and%20must%20not%20be%20attempted.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1407055%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EBizTalk%20Legacy%20SQL%20Adapter%20was%20announced%20deprecated%20long%20ago%20and%20was%20removed%20from%20the%20CD%20image%20in%20BizTalk%20Server%202020%20release.%20Many%20of%20our%20customers%20who%20are%20now%20moving%20to%202020%20release%2C%20find%20an%20additional%20work%20item%20to%20upgrade%20to%20using%20WCF-SQL%20Adapter%20in%20place%20of%20Legacy%20SQL.%20Here%20is%20a%20stop-gap-approach%20to%20deal%20with%20this%20change.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1407055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebiztalk%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBizTalk%20Adapters%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBTS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1411464%22%20slang%3D%22en-US%22%3ERe%3A%20Legacy%20SQL%20Adapter%20(Deprecated)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411464%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F565493%22%20target%3D%22_blank%22%3E%40Sanjiv380%3C%2FA%3E%26nbsp%3Bfor%20sharing%20this%20information%20with%20community.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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:

  1. You will need to bring and install the necessary pre-requisites on the machine. SQLXML 4.0 SP1 must be installed from https://www.microsoft.com/en-us/download/details.aspx?id=30403.
  2. After installing LegacySQLAdapter msi, you must add SQL adapter in BizTalk using Admin Console. This step must be performed before attempting to use this adapter in receive locations and/or send ports. Following screen shots provide some guidance on how to accomplish this task.
 

LegacySQL1.jpg

 

 

 

legacySQL2.jpg

 

 

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.

 

1 Comment
Occasional Contributor

Thank you @Sanjiv380 for sharing this information with community.