Question update a table on one server depends on table on another server

[himani_1112]

There is a database table on production server and another database table with same name on developer server.
Requirement is to update the developer database table depending on the production database entries. It should only update/insert the entries in developer database table depending on production database.
I have to create a vb.net windows application where on a button click is should update/insert the database table on developer server.

Please suggest me how can i achieve this

 

[Menthos]

Why don't you just use a trigger to insert into the development database when data is added to the production? You can add logic to the trigger to dictate what records you insert.

CREATE TRIGGER (Transact SQL)