I have a MS SQL 2005 database on one server and then a copy of that database structure on a azure server. I want to copy a specific row of data from a table from server 1 to the same table on the azure server.

The problem I have is that I do not know where to start, I am able to connect to both databases from my application. I would really like some advise on the best way to do this?

Thanks

Simon