Skip to content

configure-sql-server-pdw-for-remote-table-copies.md

Latest commit

 

History

History
45 lines (33 loc) · 2.23 KB

configure-sql-server-pdw-for-remote-table-copies.md

File metadata and controls

45 lines (33 loc) · 2.23 KB
title Remote table copies
description Describes how to configure Parallel Data Warehouse to use the remote table copy feature to copy tables to SMP SQL Server databases on non-appliance servers.
author mzaman1
ms.prod sql
ms.technology data-warehouse
ms.topic conceptual
ms.date 04/17/2018
ms.author murshedz
ms.reviewer martinle
ms.custom seo-dt-2019

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 topic 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 a 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.

  1. Log on to the active AD node (normally appliance_domain-AD01).

  2. Open the DNS Manager. This is located under Administrative Tools in the Start menu.

  3. Use the DNS Manager to add the IP name.

See Also

Use a DNS Forwarder to Resolve Non-Appliance DNS Names