December 22, 2008 at 10:39 pm
I just want to move the data from one table to another table using service broker (Both database are on diff server)
-------Please reply ASAP
December 22, 2008 at 10:53 pm
Why do you want to use service broker rather than a direct copy or extract/import? You need to provide more information on what you are trying to accomplish and what you need guidance on.
December 22, 2008 at 11:00 pm
Like matt says, there are lots of ways to move data from one table to another. Service Broker is one way, but is a lot more work than most of the other ways, so what do you need specifically about Service Broker?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 22, 2008 at 11:33 pm
Cooz its a project requirement .........so that i have to use service broker ....
December 22, 2008 at 11:49 pm
Check out this presentation and the associated code. It demonstrates how to do this.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 23, 2008 at 1:29 am
You are saying this article
Service Broker Article and tool from ALZDBA
December 23, 2008 at 1:54 am
Can u please send me the whole code ..... plzzzzzzzzzzzzzzzzzzz
December 23, 2008 at 2:23 am
Hey.... I've been referenced to :w00t: Thanks Barry 😉
The code is pointed to in the "How to use this article" section !
the word solutions has the hyperlink !.
http://www.sqlservercentral.com/articles/Service+Broker/2897/SimpleServiceBrokerSamples.zip
Take the time to understand what's going on and how to monitor your ssb system !
As already stated, for larger bulk operations, there are better alternatives for SSB. (SSIS / BCP)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 23, 2008 at 7:16 am
Actually I had intended to point to my own presentation and code, but flubbed the post (you can still find it at my blog, linked in my signature). I had not known about ALZDBA's, but it looks great too, so go with that instead. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply