|
Home > Archive > MS SQL Server > January 2006 > Looking for Solution to Remote Data Entry
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Looking for Solution to Remote Data Entry
|
|
| Greg Larsen 2006-01-31, 8:23 pm |
| I'm looking for different solution people have implemented to solve this
problem.
Problem: People need to work remotely. While working remotely they want to
gather information. This information might be survey info, or inspection
info, etc. This information is to be stored remotely on a handheld, or
laptop device. After they get back to the office/homeo office they want to
upload the information to our corporate database, which is SQL Server 2000.
This upload process should be very easy, like a like of a button, or done
automatically when the devices is docked into the corporate network. This
solution has to be supported over the Internet, and intranet.
What I'm looking for is what technologies and processes have people put in
places to implement a solution to handle the problem I stated above.
If you have more questions about what I am asking for please let me know.
| |
| Quentin Ran 2006-01-31, 8:23 pm |
| Replication is the MS SQL Server technology for this.
Quentin
"Greg Larsen" < GregLarsen@discussio
ns.microsoft.com> wrote in message
news:C353A7E9-0D0E-4DA4-85E8- 6EE8F6D754AD@microso
ft.com...
> I'm looking for different solution people have implemented to solve this
> problem.
>
> Problem: People need to work remotely. While working remotely they want
> to
> gather information. This information might be survey info, or inspection
> info, etc. This information is to be stored remotely on a handheld, or
> laptop device. After they get back to the office/homeo office they want
> to
> upload the information to our corporate database, which is SQL Server
> 2000.
> This upload process should be very easy, like a like of a button, or done
> automatically when the devices is docked into the corporate network. This
> solution has to be supported over the Internet, and intranet.
>
> What I'm looking for is what technologies and processes have people put in
> places to implement a solution to handle the problem I stated above.
>
> If you have more questions about what I am asking for please let me know.
>
>
| |
| Greg Larsen 2006-01-31, 8:23 pm |
| Are you saying you would use replication from a CE or Laptop device back to
your corporate database?
What other technologies might be available. I'm looking for all the
different technologies so I can determine what might be best and worst
methods.
"Quentin Ran" wrote:
> Replication is the MS SQL Server technology for this.
>
> Quentin
>
>
> "Greg Larsen" < GregLarsen@discussio
ns.microsoft.com> wrote in message
> news:C353A7E9-0D0E-4DA4-85E8- 6EE8F6D754AD@microso
ft.com...
>
>
>
| |
| Quentin Ran 2006-01-31, 8:23 pm |
| > Are you saying you would use replication from a CE or Laptop device back
> to
> your corporate database?
Yes that's what I am saying.
>
> What other technologies might be available. I'm looking for all the
> different technologies so I can determine what might be best and worst
> methods.
I am a SQL Server guy, not too much into other applications. One thing I
see can be useful is message queueing.
[color=darkred]
>
> "Quentin Ran" wrote:
>
|
|
|
|
|