This script will import all tables and their contents from a linked server and settle to you database, the linked server name on both the input parameter is simply the Linked Server name in your Server Objects > Linked Servers
So if your actual server and this normal entry point is the network share: "RAnBI_Lon_Ora1_Prod" but the linked server name is 'Ora_Prod_BI', then your input parameter will be 'Ora_Prod_BI'
Execute this script as is or deploy for persistent use. When deployed, the script requires the linked server name and a schema name
This script will create two support tables and drop them after use, these can be switched over to global temp-tables if necessary
Usage Examples: