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 - 2003-05-20 : 08:27:01
|
| David writes "What is the best solution to synchronize SQL Server 2000 and MSDE over the Internet.A client laptop having MSDE and WinForms .Net application installed collects data and stores them locally in MSDE. When an Internet connection is available the data should be sent to a central office to SQL Server and some information should be retrieved from SQL Server and stored in MSDE. Typical data volume for exchange is about 1 megabyte, a synchronization frequency - approximately once a week, and an Internet connection can be just dial-up. A process should be completely automated.I was thinking about a replication, SQLXML over HTTP, XML Web Services and XML files exchange.I am not sure what technology can be used in my case and what is the simplest and most reliable solution. I will greatly appreciate your help.Thanks,David" |
|
|
srf
Starting Member
42 Posts |
Posted - 2003-05-21 : 18:29:09
|
| Seems like you would want to use merge replication for that. |
 |
|
|
|
|
|
SQL -MSDE synchronization over the Internet