Friday, June 04, 2010

Transfer Data between two SQL Server's

Everyone probably knows this, but hey ho.

I needed some data from one of my tables in one server to be inserted into another, here is the simplez SQL to do it.




insert into Server1.Database.dbo.Table(Col1,Col2,Col3)
select Col1,Col2,Col3
from Server2.Database.dbo.Table



Edit:
thanks to @duncansmart just a bit more info, I'm running on 2008 R2, on previous systems you may need to run


Execute sp_addlinkedserver Server1


To link in the other Server

0 comments:

Post a Comment