Monday, 26 August 2013

Copy data from table of one server to another

Copy data from table of one server to another

How to insert data from table1 in Server1 to table1 in Server2?
I found below code but doesn't work because can't set sqlconnection for
both servers
insert into Server1.tabe1 select * from Server2.table1

No comments:

Post a Comment