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.
posted 11 years ago
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
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads