sqlsql-serverlinked-server

Insert Data From One Server To Another?

If I want to run this sort of query in SQL Server, how can I do the same query from one server I am connected to to another?

I tried adding "[ServerName1]." before "[DatabaseName1].[dbo]..." and "[ServerName2]." before "[DatabaseName2].[dbo]..." but that didn't seem to work.

INSERT INTO [DatabaseName1].[dbo].[TableName]
           ([FieldName])
     SELECT [FieldName] FROM [DatabaseName2].[dbo].[TableName]

Is this possible?

Solution

  • Yes you would use the server-name before the whole rest of object-name like:

    myserver.mydatabase.dbo.mytable

    However you first have to set up linked servers. Look up linked servers in BOL.