Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-03-11 : 08:12:53
|
| Pete writes "I have an inspection system where the inspectors use Tablet PC's to capture Inspection Results. I need to:1. Transmit details to Tablet MSDE from Head Office SQL Server 2000 of details about Inspection.2. Transmit back from Tablet any changes of details plus results of Inspection.There are about 10 tables involved and each Inspector will do around 4 inspections per day, estimate around 1MB data transfer.I need advice on should I use replication (I worry about MSDE size limit), DTS package, or another?The application is written in VB.Net so would ideally like the inspector to dial in to the internet or VPN and press a button.Thanks" |
|
|
|
|
|