Inserting data between databases

Hello, we're using SQLPro for MSSQL. Is there a way of inserting data between different databases? 

Something like this

INSERT INTO dbo.TargetTable(field1, field2, field3)
   SELECT field1, field2, field3
     FROM SourceDatabase.dbo.SourceTable
     WHERE (some condition)

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 13Views
  • 2 Following