Data availability best practices?

[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!

[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]

"Jim Hubbard" <re***@groups.please> wrote in message
news:hw*****************@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!
|
|
|

[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
"Jim Hubbard" <re***@groups.please> schreef in bericht
news:hw*****************@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!

[Jim Hubbard]

Thanks William!

This is something that I had not seen yet and looks like a great technology
to incorporate into my apps.

Jim Hubbard

"William Stacey [MVP]" <wi************@gmail.com> wrote in message
news:eV**************@TK2MSFTNGP12.phx.gbl...

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

--
William Stacey [MVP]

"Jim Hubbard" <re***@groups.please> wrote in message
news:hw*****************@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!
|
|
|