Mapping to a Different Database - BAR - Data Stream Architecture - Learn how use the XML file to map an object to a different database.

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
16.20
Published
November 2019
Language
English (United States)
Last Update
2019-11-27
dita:mapPath
xfr1514490991957.ditamap
dita:ditavalPath
3150_DSA_UG_1650-working-RR-new.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
You can map an object to a different database so that it is restored to the destination system under a different user or database than was originally designated for the backup job. You do this using the map_to tag in the XML file containing the job definition.
  1. Open the XML file containing the job definition information.
  2. Under objectinfo, identify the object, and add the new database name inside map_to. The following example restores table T1, originally backed up from database ABC, to database NEWBAR:
    <objectinfo>
       <object_name>T1</object_name>
       <object_type>TABLE</object_type>
       <parent_name>ABC</parent_name>
       <parent_type>DATABASE</parent_type>
       <object_attribute_list>
          <map_to>NEWBAR</map_to>
       </object_attribute_list>
    </objectinfo>
    
    You can also use map_to in the job_options section.