You must Sign In to post a response.
  • Category: BizTalk

    How to insert Data to One SQL Server Data Base To Other SQL Server Data Base Using Biz-tal


    I have two database for the application, One
    1)Contact Management
    2)Customer Management

    There is one table for manage the contact.
    in both database ConatactDetail Table is there. Now both have different application.

    Now i want to do that while i am entering data in one application's database that will also insert into other database also using biz-talk.

    How can i implement this functionality ? I am new in biz-talk, I have idea about the Schema, Mapping, Pipeline, Receive Port, Send Port from Video tutorial. I have not much idea about the Orchestration. I want tutorial that will give the step by step implementation of this type of functionality.

    So any one who have done this type of functionality in Biz-talk 2010 than reply me.

    Thanks Ragards
    Hardik Ramwani
  • #711241
    1] You can use WCFSQl/SQl adapter to insert into one database and if the insert is successful use another WCFSQl/SQL adapter to insert into the other database. If the second insert is unsuccessful you will have rollback your previous insert. For this you will have to use compensation logic.
    For WCF SQL sample please refer below link:

    2] Else you can write SQl script to insert into both the databases table at the same one go only... and then use WCFSQl adapter in your orch to call that SQL script.
    **You need to set the the time out properly in this case, if the execution of SQL script takes time.

    Pratyush Ranjan

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.