I've got two tables with identical structure. I'm trying to create a synchronize procedure that will be triggered by a scheduled event at a given time every day.
truncate table [localserver].[DBName].dbo.linktest
insert into [localserver].[DBName].dbo.linktest
Instead of inserting every single row on every execution, like in my scrpt, is it possible to only insert new rows on local server ?
This would greatly increase the execution speed, since it doesn't have to insert all the 4000 rows when maybe only 20 new rows.
Please advise how to modify above script to insert only new rows (append) on every execution instead of all 4000 rows.