Joined:	11/06/2009
Level:	Silver
Points:	109

Points:	5

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

Hello,

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

Joined:	08/04/2013
Level:	Bronze
Points:	40

Points:	4

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:
http://www.codeproject.com/Articles/37808/How-to-invoke-Stored-Procedures-with-the-FOR-XML-c

2] Else you can write SQl script to insert into both the databases table at the same time.in 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.

Regards,
Pratyush Ranjan

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

About dotnetspider.com

Quick Links

General

Services