This article is tagged with:
Sql select data from one database and insert into a different database
and mysql
sql select data from one database and insert into a different database
USE TargetDatabase
GO
INSERT INTO dbo.TargetTable(field1, field2, field3)
SELECT field1, field2, field3
FROM SourceDatabase.dbo.SourceTable
WHERE (some condition)