- This topic has 6 replies, 1 voice, and was last updated 6 years, 11 months ago by
.
-
Posts
-
-
Hello,
i am new to BIztalk. i am facing a scenario where i have to integrate the SQL Server Database to another SQl Server Database using BIztalk.
Can somebody guide me in this regards. The scenario is simple i.e. if a change is made in a table of one database then the Biztalk should sense the change and make the same change in another database. plz help me solve this scenario.Regards,
Jan. -
thanx but i have been given this scenario to solve. just bcz i should know how to integrate b/w the two databases of SQL server. definitely the actual problem is not like that. it will be communicated to me later. so if u can just guide me how to integrate the two sql server database, i shall be thankful.
Regards,
Jan.-
[quote=\”NISHIL\”]First let me know \”changes in source Sql table\” means what.
Did you meant changes in design…if so then biztalk cant help you.
If you meant changes in data…insertion or deletion or updation of data then you can easily reflect it in the other table using Sql adapter at both ends. See Sql adapter depends upon the Stored procedure you call. So if you stored procedure can sense the changes then you can reflect it or else youll have to handle it inside orchestration that what is to be done….So be clear with the requirements. In any scenario you need the primary key of one column…..and the operation to be performed…Just concentrate how would you get these 2 things.Regards
NISHIL
http://biztalkblogs.com/nishil/default.aspx%5B/quote%5Dlike this: testdb testtable(a int, b int, c char)(exp:(12,23, a))–>desdb destable(c int, d int, e char)(the result is (12, 23 + 10, ab))
maybe, jan want to get this example.
iwant to ask you how i should do : sql adapter -> select statement(port type)-> select a, b, c from testtable(how to write the statement in the window)-
First let me know \”changes in source Sql table\” means what.
Did you meant changes in design…if so then biztalk cant help you.
If you meant changes in data…insertion or deletion or updation of data then you can easily reflect it in the other table using Sql adapter at both ends. See Sql adapter depends upon the Stored procedure you call. So if you stored procedure can sense the changes then you can reflect it or else youll have to handle it inside orchestration that what is to be done….So be clear with the requirements. In any scenario you need the primary key of one column…..and the operation to be performed…Just concentrate how would you get these 2 things.Regards
NISHIL
http://biztalkblogs.com/nishil/default.aspx-
I am bizTalk server newbie too, but I know a lot about mssql server. I am not sure you really need to use biztalk server to solve your problem. Functionality you described is well supported by sql server itself.
If your databases are on the same server you can use a trigger. If they are on different servers you can use replication.
-
By change in database mean change in data. e.g. insert or update.
also if u can help me with some example or with some detailed steps to be followed, i shall be thankful.
Regards,
Jan-
Hi,
i think jan is also facing the same problem as i m facing. Scenario is as follows.1) I have a customer table in online POS application using sql server.
2) I have a CRM application using sql server with customer table.
3) Now i want to update the CRM customer table as soon as new customer is added in POS customer table.
what would be the solution in biztalk.
[b:75258d850f]Best Regards
Imran Shabbir[/b:75258d850f]
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.