Copying Specific Tables - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
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>