Questions about migrating from former BizTalk SQL Server adapter to WCF-based adapter RRS feed

  • Question

  • Hello Everyone - I have a BizTalk 2009 application that has quite a few maps that use a schema from the older SQL Server Adapter.  I'm considering the issues of migrating the application to the WCF-based SQL Server Adapter and one of the questions pertains to performance.  Is there a performance difference between the two adapters and if so, is it significant?  The adapter in my application calls a stored procedure which makes two simple SELECT queries and one INSERT statement.  I'm doubting that there would be any real difference in this case.

    I'm very concerned with how the schema changes when using the WCF-based adapter - BizTalk indicated that most, if not all, of the links in my maps would be lost and I'd have to recreate all of them.  Yikes.

    What have been your experiences migrating to the WCF one?  Thanks in advance for all of your ideas!

    - Anthony
    Friday, January 29, 2010 4:12 PM