create event from service broker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 12 Jun 2008 11:26 GMT

Hello there

I have some tables i would like to create event on these tables that each
data change made on these tables will be written to service broker queue so
I can apply this change in another databases on another servers.

How can i do it?

Reply to this Message

Tom Moreau - 12 Jun 2008 12:04 GMT

Consider using replication for this. That is what it is designed to do.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Reply to this Message

Roy Goldhammer - 12 Jun 2008 13:12 GMT

Replication is not good because i don't need to move the data as it is from
one server to antother.

I take the data, do some processing on it and then set it on the second
server.

and it seems that service broker is made for this

so how can i do it on service broker?

> Consider using replication for this. That is what it is designed to do.
>
[quoted text clipped - 6 lines]
>
> How can i do it?

Reply to this Message

Adam Machanic - 12 Jun 2008 16:44 GMT

Either technology will work for this. With transactional replication you
would just have to tweak the stored procedures that it creates.

You can do it with SSB, too. Here are two articles you can start with:

http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/
http://www.simple-talk.com/sql/learn-sql-server/service-broker-advanced-basics-w
orkbench/

--
Adam Machanic
http://sqlblog.com

> Replication is not good because i don't need to move the data as it is
> from one server to antother.
[quoted text clipped - 16 lines]
>>
>> How can i do it?

Reply to this Message