I need to programmatically (ADO.Net) copy records from a table in one database to a table in another database on a different server.
This is very similar to "How can I copy data records between two instances of an SQLServer database" except that I am not allowed to create a link to the destination server so the accepted answer to that question won't work for me.
Sql – How to copy data records between two instances of an SQLServer database
copydatabasesql-server-2005
Best Answer
You can use the SqlBulkCopy class