maybe something like

insert into devsrv.devdb.dbo.devtab (col1, ... coln)

select col1,... coln from prodsrv.proddb.dbo.prodtab

where datecol between starttime and endtime