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

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


Post a Comment