Shafat Husain (12/24/2014)
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...!!
YOu could use MERGE, but if you are pulling the entire set every time and using MERGE, then performance is going to degrade pretty quickly. If you have a timestamp (datetime column) that you can use to know what is new/changed, doing incremental loading will be faster then using MERGE.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question