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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
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>