Data availability best practices?

23 Mar 2006 3:25 AM

Jim Hubbard

I have a client that wants me to code a simple application as a prototype.
The catch is that he wants to use this application at several different
stores while being able to share each store's data. He also want the
application to continue to function in the case that the internet is down
for any reason.

I have my own theories as to how to accomplish this shared data environment,
but I'd love to hear your ideas about sharing data real-time (when the
connection is available) and being able to continue to run even when the
connectivity to other stores or a main data storage server is unavailable.

Keeping bandwidth and complexity to a minimum are desired characteristics.

Thanks!

23 Mar 2006 3:59 AM

William Stacey [MVP]

I might think about Sql Express at the remote sites and use Service Broker
to pass updates to master site.

--
William Stacey [MVP]

Show quoteHide quote

"Jim Hubbard" <reply@groups.please> wrote in message
news:hwoUf.2495$lM3.2184@bignews3.bellsouth.net...
|I have a client that wants me to code a simple application as a prototype.
| The catch is that he wants to use this application at several different
| stores while being able to share each store's data. He also want the
| application to continue to function in the case that the internet is down
| for any reason.
|
| I have my own theories as to how to accomplish this shared data
environment,
| but I'd love to hear your ideas about sharing data real-time (when the
| connection is available) and being able to continue to run even when the
| connectivity to other stores or a main data storage server is unavailable.
|
| Keeping bandwidth and complexity to a minimum are desired characteristics.
|
| Thanks!
|
|
|

23 Mar 2006 7:49 AM

Cor Ligthert [MVP]

Jim,

I know only that it exist. However I should start contacting Microsoft in
your region how the Biz Talk server could help you.

http://www.microsoft.com/biztalk/default.mspx

I hope this helps,

Cor

Show quoteHide quote

"Jim Hubbard" <reply@groups.please> schreef in bericht
news:hwoUf.2495$lM3.2184@bignews3.bellsouth.net...
>I have a client that wants me to code a simple application as a prototype.
> The catch is that he wants to use this application at several different
> stores while being able to share each store's data. He also want the
> application to continue to function in the case that the internet is down
> for any reason.
>
> I have my own theories as to how to accomplish this shared data
> environment,
> but I'd love to hear your ideas about sharing data real-time (when the
> connection is available) and being able to continue to run even when the
> connectivity to other stores or a main data storage server is unavailable.
>
> Keeping bandwidth and complexity to a minimum are desired characteristics.
>
> Thanks!
>
>
>