Service Broker

11 Sep 2006 9:40 AM

yugant

Hello , I am trying to Implement distribution of the Stock Quotes over
the LAN(only within the Network) and showing the live changing stock
Quotes on the front end (in datagrid) installed at each clients
desktop.I am receiving the Stock prices over the TCP / IP from the
Stock Exchange. I am recieving atleast 10-15 messages per second over
the TCP / IP from the Stock Exchange. Now i need to distribute this
feed to Each connected client.

I tried doing it from TCP / IP , but in vein. Can we install the SQL
2005 Database Client Version on every client and use Service broker
instaed of Live TCP / IP connections programmatically?

Ideally Can i dump the meesages from Stock Exchange in to each
connected client's database locally and each front end application will
keep a record of all the incomming messages.i.e Front end have a
notification event , it will referesh the Datagrid in Front end
accordingly...

ALL my front end application are made in dot net

Pls suggest if this above workflow will help me

Yugant

11 Sep 2006 2:55 PM

Roger Wolter[MSFT]

I'm not sure I understand your application but you could definitely have a
central SQL Server Standard Edition database the communicates to and from
SQL Express databases on the clients. These messages would be reliable and
be delivered in spite of network, server or client failures.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

<yug***@gmail.com> wrote in message

Show quoteHide quote

news:1157967606.968125.267500@h48g2000cwc.googlegroups.com...
> Hello , I am trying to Implement distribution of the Stock Quotes over
> the LAN(only within the Network) and showing the live changing stock
> Quotes on the front end (in datagrid) installed at each clients
> desktop.I am receiving the Stock prices over the TCP / IP from the
> Stock Exchange. I am recieving atleast 10-15 messages per second over
> the TCP / IP from the Stock Exchange. Now i need to distribute this
> feed to Each connected client.
>
> I tried doing it from TCP / IP , but in vein. Can we install the SQL
> 2005 Database Client Version on every client and use Service broker
> instaed of Live TCP / IP connections programmatically?
>
> Ideally Can i dump the meesages from Stock Exchange in to each
> connected client's database locally and each front end application will
> keep a record of all the incomming messages.i.e Front end have a
> notification event , it will referesh the Datagrid in Front end
> accordingly...
>
> ALL my front end application are made in dot net
>
> Pls suggest if this above workflow will help me
>
> Yugant
>

12 Sep 2006 8:12 AM

yugant

Thanks Roger.. U mean to say i should have a central SQL server 2005
installed on the server and this server will throw data to every sql
client installed on the client machine...
Can u pls let me know how can i forward the data to all (say 200)
client SQL databse from one central server ....

AND once the data reaches any client the front end application can talk
to the local databse through service broker....

Yugant

Roger Wolter[MSFT] wrote:
Show quoteHide quote

> I'm not sure I understand your application but you could definitely have a
> central SQL Server Standard Edition database the communicates to and from
> SQL Express databases on the clients. These messages would be reliable and
> be delivered in spite of network, server or client failures.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> <yug***@gmail.com> wrote in message
> news:1157967606.968125.267500@h48g2000cwc.googlegroups.com...
> > Hello , I am trying to Implement distribution of the Stock Quotes over
> > the LAN(only within the Network) and showing the live changing stock
> > Quotes on the front end (in datagrid) installed at each clients
> > desktop.I am receiving the Stock prices over the TCP / IP from the
> > Stock Exchange. I am recieving atleast 10-15 messages per second over
> > the TCP / IP from the Stock Exchange. Now i need to distribute this
> > feed to Each connected client.
> >
> > I tried doing it from TCP / IP , but in vein. Can we install the SQL
> > 2005 Database Client Version on every client and use Service broker
> > instaed of Live TCP / IP connections programmatically?
> >
> > Ideally Can i dump the meesages from Stock Exchange in to each
> > connected client's database locally and each front end application will
> > keep a record of all the incomming messages.i.e Front end have a
> > notification event , it will referesh the Datagrid in Front end
> > accordingly...
> >
> > ALL my front end application are made in dot net
> >
> > Pls suggest if this above workflow will help me
> >
> > Yugant
> >

12 Sep 2006 2:13 PM

Roger Wolter[MSFT]

I can't realistically design an application through a newsgroup but
basically each client would have to establish a dialog to the server and
when the server had information to send out, it would send a message on each
of the dialogs that have been established. Dialogs are bi-directional so
the clients can send messages to the server over the same dialog. Dialogs
are persistent so they only have to be established once and then can be used
as long as they're needed.

You will need to do some reading to get a handle on Service Broker. Books
online has a lot of good conceptual material. here's some more
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp
If you want a lot more information I recommend:
http://www.amazon.com/Rational-Server-Service-Broker-Guides/dp/1932577270/sr=1-1/qid=1158009357/ref=pd_bbs_1/103-0049023-7244631?ie=UTF8&s=books

There are also a few service broker articles on my blog:
http://blogs.msdn.com/rogerwolterblog/default.aspx

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

<yug***@gmail.com> wrote in message

Show quoteHide quote

news:1158048736.978769.320820@d34g2000cwd.googlegroups.com...
> Thanks Roger.. U mean to say i should have a central SQL server 2005
> installed on the server and this server will throw data to every sql
> client installed on the client machine...
> Can u pls let me know how can i forward the data to all (say 200)
> client SQL databse from one central server ....
>
> AND once the data reaches any client the front end application can talk
> to the local databse through service broker....
>
> Yugant
>
> Roger Wolter[MSFT] wrote:
>> I'm not sure I understand your application but you could definitely have
>> a
>> central SQL Server Standard Edition database the communicates to and from
>> SQL Express databases on the clients. These messages would be reliable
>> and
>> be delivered in spite of network, server or client failures.
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>>
>> <yug***@gmail.com> wrote in message
>> news:1157967606.968125.267500@h48g2000cwc.googlegroups.com...
>> > Hello , I am trying to Implement distribution of the Stock Quotes over
>> > the LAN(only within the Network) and showing the live changing stock
>> > Quotes on the front end (in datagrid) installed at each clients
>> > desktop.I am receiving the Stock prices over the TCP / IP from the
>> > Stock Exchange. I am recieving atleast 10-15 messages per second over
>> > the TCP / IP from the Stock Exchange. Now i need to distribute this
>> > feed to Each connected client.
>> >
>> > I tried doing it from TCP / IP , but in vein. Can we install the SQL
>> > 2005 Database Client Version on every client and use Service broker
>> > instaed of Live TCP / IP connections programmatically?
>> >
>> > Ideally Can i dump the meesages from Stock Exchange in to each
>> > connected client's database locally and each front end application will
>> > keep a record of all the incomming messages.i.e Front end have a
>> > notification event , it will referesh the Datagrid in Front end
>> > accordingly...
>> >
>> > ALL my front end application are made in dot net
>> >
>> > Pls suggest if this above workflow will help me
>> >
>> > Yugant
>> >
>