Excluding Tables When Replacing a Database - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
You can exclude a table when replacing a database by specifying its name. Excluding a table that exists on the target does not remove the existing target table.
  1. Set <replaceDatabase="true"> to replace the specified database.
  2. Set <table selection="excluded"> and then specify the table name.
In the following example the target database is replaced with the source database but the Customers table is not copied to the target.
If the Customers table already exists on the target, excluding it in the XML as shown below does not remove it from the target.
<database selection="included" replaceDatabase="true">
     <name>MyDatabase</name>
     <table selection="excluded">
          <name>Customers</name>
     </table>
 </database>