Edit

Share via

Tutorial 1: Migrate BizTalk Projects to the SQL adapter

  • Article

The previous version of the SQL adapter that shipped with Microsoft BizTalk Server differs from the WCF-based SQL adapter in many aspects, including:

  • The design-time experience of creating a BizTalk project.

  • The metadata retrieval experience.

  • Schema file name and namespace.

  • Data type mappings.

  • The operations that can be performed using the adapter.

  • Physical port configuration in the BizTalk Server Administration console

    These differences are explained in the topics within Migrating BizTalk Projects Created Using the Previous Version of the SQLadapter.

    However, you can make changes to the BizTalk project that was created using the previous version of the adapter and make it work with the WCF-based SQL adapter.

    This tutorial provides instructions on the changes you should make to the existing BizTalk project created using the previous version of the adapter.

Note

In this tutorial, for the sake of brevity, the previous version of the SQL adapter will be referred to as vPrev SQL adapter. Similarly, a BizTalk project that uses the vPrev SQL adapter will be referred to as vPrev BizTalk project.

Important

This tutorial provides guidance on how to migrate a vPrev SQL adapter BizTalk project that performs a basic insert operation on a SQL Server database table. This tutorial does not cover all possible scenarios for migration from the vPrev SQL adapter to the new WCF-based SQL adapter. You must use this migration tutorial as a foundation and modify accordingly to make changes that are relevant to your existing project.

Sample Used for the Tutorial

This tutorial is based upon a sample (SQL_Migration) that demonstrates how to migrate a vPrev BizTalk project. The sample is provided with Microsoft BizTalk Adapter Pack. For more information, see Samples.

Prerequisites

  • You must have a vPrev BizTalk project. This tutorial involves a BizTalk project that performs an Insert operation on a Customer table in the SQL Server database. The Customer table has the following design:

    Column Name Description
    v_custid Primary key, integer type, identity field
    Name nchar(10) type

  • You must have a request message to perform an Insert operation on the SQL Server database using the vPrev SQL adapter. The request message must conform to the schema of the Insert operation generated using the vPrev SQL adapter.

  • Be familiar with the creating BizTalk projects in Visual Studio. For more information, see Using the BizTalk Project System.

Understanding a BizTalk Project Created Using the Previous Version of the Adapter

The key constituents of a vPrev BizTalk project created are:

  • BizTalk orchestration. This is a simple orchestration that picks request messages from a file location, sends the request message to the SQL Server database using a WCF-Custom send-receive port, receives the response, and saves it to another file location.

  • Schema for the operation you wish to perform on the SQL Server database. This tutorial involves a BizTalk project that performs an Insert operation on the Customer table. The schema generated for the Customer table is InsertCustomerService.xsd. This schema is generated using the vPrev SQL adapter.

  • Request message. The request message to perform an Insert operation on the Customer table. The schema of the request message conforms to the schema of the Insert operation as surfaced by the previous version of the SQL adapter.

How to Migrate a BizTalk Project Created Using the Previous Version of the Adapter

The goal of this migration tutorial is to enable you to send a request message, which conforms to schema generated by vPrev SQL adapter, using a WCF-Custom port that can only process messages conforming to the WCF-based SQL adapter. So, in short, the migration exercise involves configuring the WCF-Custom port to process messages that do not conform to the WCF-based SQL adapter's schema.

However, to be able to configure the WCF-Custom port appropriately, you must perform the following tasks:

  • Generate metadata for the Insert operation on the Customer table using the WCF-based SQL adapter.

  • Map the request message for performing an Insert operation using the vPrev SQL adapter to a request message for performing an Insert operation using the WCF-based SQL adapter.

  • Map the response message received using the WCF-based SQL adapter to the response message for the vPrev SQL adapter.

  • Create a WCF-Custom SQL send-receive port in the BizTalk Server Administration console.

  • Configure the WCF-Custom port to use the request and response mappings.

In This Section

See Also

SQL Adapter Tutorials