Introducing the Migration Tool for Microsoft BizTalk Adapters for Enterprise Applications

For customers currently using the Microsoft BizTalk Adapters for Enterprise Applications (aka the LOB adapters) and willing to migrate their existing projects to the WCF-based LOB adapters, here's a tool that will help you migrate your projects to work with BizTalk Adapter Pack 2.0.

Before we start talking about the tool and the adapter projects it can be used against, let us set the ground by laying the rules for the naming convention that we will be using here:

  • Microsoft BizTalk Adapters for Enterprise Applications adapters are referred to as n

    on-WCF LOB adapters.

  • Adapters part of BizTalk Adapter Pack 2.0 are referred to as WCF-based LOB adapters.

What does the tool do?

The migration tool accepts BizTalk project/Solution files containing schemas generated by non-WCF LOB adapters and generates corresponding new BizTalk project/solution files having schemas corresponding to the WCF-based LOB adapters, with the maps and orchestrations modified accordingly. This tool helps you to migrate the projects for the following adapters:

  • BizTalk ODBC Adapter for Oracle Database
  • BizTalk Adapter v2.0 for mySAP Business Suite
  • SQL adapter

Where to get the tool from?

You can download the tool from https://go.microsoft.com/fwlink/?LinkID=153328. The tool also includes a migration guide that describes:

  • How to run the tool
  • What steps to follow after the tool has finished migrating the project
  • Limitations of the migration tool.

Comments

  • Anonymous
    November 11, 2009
    HiIf you are interested in feedback, we have noticed the tools fails migrating maps where one of the schemas is in an external assembly.For instance if using it to migrate a SAP project to WCF, the old SAP schema is inside the solution, but if the destination schema is in another assembly that is referenced, the tool fails to migrate the map with the error"Destination Schema of the map was not found"The work around we have used is to take a copy of the schemas and attach into the project, and update the maps to the local schema instead of the referenced schema, prior to using the migration tool.The tools then runs successfully - how it is a clumsy and time consuming work around.
  • Anonymous
    November 14, 2009
    Thanks PeterZ, for your valuable feedback.The current requirement of the tool states that all the artifacts(schemas/maps/orchestration) to be migrated should be present in the solution being migrated.So, in the current design, for making the tool work, you can just add the project(which produces the referenced dll) to the current solution. And in the migtation wizard, specify the .sln file instead of the btproj.The migration should work correcly.
  • Anonymous
    October 25, 2010
    Hi,I'm a bit confused. Could you confirm that BizTalk LOB Adapters 2010 Beta available recently before BizTalk 2010 RTM is referred to as non-WCF LOB adapters. It is no longer available and only BizTalk Adapter Pack 2.0 and WCF LOB Adapters SDK is available for 2010?Thanks.
  • Anonymous
    October 25, 2010
    Hi,I'm a bit confused. Could you confirm that BizTalk LOB Adapters 2010 Beta available recently before BizTalk 2010 RTM is referred to as non-WCF LOB adapters. It is no longer available and only BizTalk Adapter Pack 2.0 and WCF LOB Adapters SDK is available for 2010?Thanks.
  • Anonymous
    November 10, 2010
    non-WCF LOB adapters are the old  aadapters -  availabe at  www.microsoft.com/.../details.aspxwww.microsoft.com/.../details.aspxthe adapters from which migration is availabe are -Microsoft BizTalk ODBC Adapter for Oracle DatabaseMicrosoft BizTalk Adapter for Siebel eBusiness Applicationsand Microsoft BizTalk Adapter v2.0 for mySAP Business Suite Service Pack 1I think BizTalk LOB Adapters 2010 Beta  would be the WCF base adapters from Biztalk Adapter Pack.
  • Anonymous
    January 07, 2011
    A new version of the tool is now available.BizTalk Adapter Pack Migration Tool 2.0 can be downloaded from Microsoft Download: www.microsoft.com/.../details.aspxList of changes from Biztalk Adapter Pack Migration Tool 1.0 :Bug FixesOption to remember URI and Username. Option to create dummy nodes in existing SAP RFC related maps, so that the new adapter can return all tables in the response message. Option to promote properties in new schema corresponding to promoted properties in the old schema. Added detailed error logging, when map generation for SAP RFCs and IDOCs fails. Detailed release notes are included in the downlaod package.