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 Administration (2000)
 Selective Data Exchange between local and remote server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-25 : 01:43:30
santhu writes "I have a scenario here.I have a local server(a LAN server with SQL server database) which once a day connects to internet on dial up and then we have a web server (NT server)on one end .We want to update / insert 1-2 tables in the web server with a few selected columns with the changed entries/ new entries in the corresponding columns in the local server when we connect the local server to the internet. My web server is on shared server so I may not get permission to practice replication in this case.
What could be a methodology to conduct data exchange in this case? I repeat, we need data from only selected columns of 1-2 tables and the data may be modified data and/or also new data in those columns."
   

- Advertisement -