If you have set appropriate table adapter properly, it should be sufficient to call Clone() on the DataTable (don't forget cast the result, because Clone() returns object), open connection to destination database and call Update() on cloned table.