Hi,

Just a thought..!!

Why not use MERGE to get the data from these tables in your local database.

You can schedule a Job using Sql server Agent to run the Merge command or you can develop a SSIS package to do the same task.

Hope it Helps...!!