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 - 2005-07-12 : 07:13:09
|
| Prajosh writes "Respected SirI am currentlty doing a poject(Academic) for a Parcel Service company in India. They have defferent branches in all over india. They want to update daily booking information into the local server.Could ou please help me how to solve this plm?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-12 : 07:53:26
|
| I reckon you have a number of routes you could consider:1. Use Replication from Remote server2. Use DTS to get data into local server3. Export the data (i.e. using BCP) on remote server, transfer to local server, re-import using BCP4. Use XML to export the data from remote server and "post" it to the local server.Kristen |
 |
|
|
|
|
|
Data Transfer between local server and web server