Import Over Linked Server

Owned by Steve Martin
Last updated: 03 Jan, 2021
1 min read

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: