Can you tell me how to copy table data from one database to another.
Each of database is on different Server.
I need to copy data from Table1 on server1\sqlexpress to Table2 which is on server2\sqlexpress.
Databases are identical in structure.
I know how to copy with Microsoft SQL Managment studio Right click on database--> Export data. But i need code solution that will be executed from VB Program.
Thank you in advance.
P.S. I will never need old data from server2 so let's say that destination table will be empty.