I don't know why you want to use webservice. But easy way is to use Datatable to store Temporarily data. This can work if both databases are on same domain. I use free sqlhepler class to connect with database. ------------------------------------------------------------------------------ string sql="Select user_id,name from user_master"; DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionStringfordatabase1, CommandType.Text, sql); foreach (DataRow dr in dt.Rows) { sql = "Inser into user_master (user_id,name) values('" + dr["user_id"] + "','" + dr["name"] + "')"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringfordatabase2, CommandType.Text, sql); } ------------------------------------------------------------------------------
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India