Create tables based off structure and data from a linked server

[ljwilson]

I am trying to create tables and insert data based on a linked server. The linked server may not always be available so we need to have a local copy of the data. Since I am not in control of the linked server, I won't know when table structure changes. Is there a way to create a SP that will select from the linked server tables and then create the structure for the local database tables and then insert all the rows?

 

[gmmastros]

What is the desired behavior if you have data in your local table and the structure on the linked server changes? Do you want to modify the local table to match, or are you ok with dropping the table and rebuilding it?


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom