I am trying to update a table with another table when any rows are missing. I tried the MERGE command, but I get the following error:

MERGE INTO Genentech_test.EDSVisitSchedule
USING Persia.Genentech.EDSVisitSchedule
ON Genentech_test.EDSVisitSchedule.order = Persia.Genentech.EDSVisitSchedule.order
WHEN NOT MATCH THEN
INSERT VALUES(Persia.Genentech.EDSVisitSchedule.order, Persia.Genentech.EDSVisitSchedule.value)

Incorrect syntax near the keyword 'INTO'.

After doing some research, I found out that the 'INTO' of the MERGE command is not supported in SQL Server 2005. Does anyone have any alternatives for this?

Thanks.