Configure Parallel Data Warehouse for remote table copies
Describes how to configure SQL Server PDW to use the remote table copy feature to copy tables to SMP SQL Server databases on non-appliance servers.
This article describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see Remote Table Copy.
Before you begin
In order to configure SQL Server PDW to use remote table copy, you must:
Have an Analytics Platform System administrator account with the ability to log directly into the appliance_domain-AD01 and appliance_domain-AD02 nodes.
Know the host name or IP name of the destination server.
Configure SQL Server PDW for Remote Table Copy: Update Host Names in DNS
The CREATE REMOTE TABLE statement, used for remote table copies, specifies the destination server by using either the IP address or the IP name of the SMP Windows system. To use the IP name, you need to add entries for successful name resolution to the DNS server.
The following steps outline how to update the DNS server.
Sign in the active AD node (normally appliance_domain-AD01).
Open the DNS Manager. This is located under Administrative Tools in the Start menu.
Use the DNS Manager to add the IP name.
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for