Both the server and the client have the same database structure. When the database on the server changes, the data in the client's database needs to be updated as the data in the server database changes.
Many technologies can meet your requirements. The simplest and most straightforward one should be to use DTS. If complex application control is required, use .net as a webservice.
In addition to looking at the network structure, you also need to look at the update frequency.The update frequency is different, and the update method selected is different.