-- This script to be run on database2 to pull in data from database1 INSERT INTO database2_dev.dbo.tablename (cols) SELECT cols FROM database1_dev.dbo.tablename