Replace and Relocate a Database | Teradata Data Mover - Replacing and Relocating a Database - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

When you replace a database, you may also choose to relocate it.

  1. Set replaceDatabase to true, and specify the name of the source database.
  2. Under the target_database element, specify the name of the location where you want to copy the source database.
In the following example, all objects in the MyTargetDB database are eliminated and objects from the source MySourceDB database are copied to the target database MyTargetDB. Thus MyTargetDB is replaced with MySourceDB.
<database selection="included" replaceDatabase="true">
     <name>MySourceDB</name>
     <target_database>
           <name>MyTargetDB</name>
     </target_database>
</database>