Copy Specific Tables | Teradata Data Mover - Copying Specific Tables - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
You can copy an entire database and its children, but specify that only specific tables in one of the child database be copied.
  1. Add the selection="unselected" attribute to the database element.
  2. Specify the name of the child database.
  3. Add the selection="included" attribute to the table element.
  4. Specify the name of the table of the child database to be copied.
In the following example, the MyDatabase database and all its children except MyDB_Child are copied to the target. However, the MyDB_Child.call_hist table is copied to the target.
<database selection="all"> 
<name>MyDatabase</name> 
	<database selection="unselected"> 
	<name>MyDB_Child</name> 
		<table selection="included"> 
			<name>call_hist</name> 
		</table> 
 </database> 
</database>