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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Sync head office SQL Server 2000 data with Tablet PC MSDE 2000

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"
   

- Advertisement -