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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
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>