You could do this is SSIS, and you wouldn't have to rely on a linked server. Use a Foreach Loop Container to loop thru all of the tables, and pick the most appropriate method of doing the inserts/updates to the target database. It's easier to keep track of intermediate results in SSIS, doing fancy joins thru a linked server could have horrible performance.