| Author |
SQL Server Adapter
|
|
|
|
Hi,
I have a SQL Server DB which biztalk monitors for any new or updated
records.
Is there any way to let biztalk know that a record needs to be picked
instead of biztalk constantly polling sql server
-Regards,
| |
| McGeeky 2006-01-24, 5:59 pm |
| I have considered using a SQL Server trigger. The trigger would then write
out a file or something to communicate this to BizTalk. But I never took
this through to completion.
I find that polling SQL Server is suitable in most scenarios and is a breeze
to set up.
What is your motivation for event based rather than polling based
notification?
--
McGeeky
http://mcgeeky.blogspot.com
"Kallu" <Kallu@discussions.microsoft.com> wrote in message
news:6166F868-149F-40B9-B473-673CB3EF856C@microsoft.com...
>
> Hi,
>
> I have a SQL Server DB which biztalk monitors for any new or updated
> records.
>
> Is there any way to let biztalk know that a record needs to be picked
> instead of biztalk constantly polling sql server
>
>
> -Regards,
| |
|
|
Hi McGeeky,
The data would be read from different tables and i thought if theres any
other efficient way to get the messages(records)
Would it be possible for the Trigger to write the messages to MSMQ?
-Regards,
"McGeeky" wrote:
> I have considered using a SQL Server trigger. The trigger would then write
> out a file or something to communicate this to BizTalk. But I never took
> this through to completion.
>
> I find that polling SQL Server is suitable in most scenarios and is a breeze
> to set up.
>
> What is your motivation for event based rather than polling based
> notification?
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Kallu" <Kallu@discussions.microsoft.com> wrote in message
> news:6166F868-149F-40B9-B473-673CB3EF856C@microsoft.com...
>
>
>
| |
| McGeeky 2006-01-25, 8:32 am |
| I have not done it myself (accessing MSMQ from a trigger), but T-SQL is
pretty powerful and virtually anything is possible; for example using COM or
running an external program. But it starts to get a bit messy. It might be
more trouble than its worth. Perhaps you should look further up-stream to
see what is writing the data in the first place and if that is a more
suitable place to put a hook in to BizTalk.
If you do have some success with a trigger then please let me know as I'd be
interested to see how you get on.
--
McGeeky
http://mcgeeky.blogspot.com
"Kallu" <Kallu@discussions.microsoft.com> wrote in message
news:19EC10F2-D284-4CA6-9681-C445C0DF02F1@microsoft.com...[vbcol=seagreen]
>
> Hi McGeeky,
>
> The data would be read from different tables and i thought if theres any
> other efficient way to get the messages(records)
>
> Would it be possible for the Trigger to write the messages to MSMQ?
>
>
> -Regards,
>
> "McGeeky" wrote:
>
| |
|
|
Sure, thanks for your suggestion
-Regards,
"McGeeky" wrote:
> I have not done it myself (accessing MSMQ from a trigger), but T-SQL is
> pretty powerful and virtually anything is possible; for example using COM or
> running an external program. But it starts to get a bit messy. It might be
> more trouble than its worth. Perhaps you should look further up-stream to
> see what is writing the data in the first place and if that is a more
> suitable place to put a hook in to BizTalk.
>
> If you do have some success with a trigger then please let me know as I'd be
> interested to see how you get on.
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Kallu" <Kallu@discussions.microsoft.com> wrote in message
> news:19EC10F2-D284-4CA6-9681-C445C0DF02F1@microsoft.com...
>
>
>
|
|
|
|