If you don't need to do it in code, you could use DTS.
If you need to do it in code, you can open connections to both databases, and select from one and insert into the other.
Joined: Sep 19, 2005
thanks for the reply, we have decided not to use DTS and we have the query to do the data transfer
suppose a user clicks on a link on a web page it should automatically get the data from the server database ( this is simple as the application recides in the server ) and update in the client here we should establish a connection to the client database how to do that