Renaming a Database - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10.01
Published
November 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
fyx1509665931452.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
Product Category
Software
Teradata Tools and Utilities
You can rename a database in a restore job by adding map_to to the table in the XML file containing the job definition. This option restores the database to the target system using a new name for the database.
  1. Open the XML file containing the job definition information.
  2. Under objectinfo, identify the database to rename and add the new database name inside map_to. In the following example, the objects under database ABC are copied to database NEWBAR:
    <objectinfo>
       <object_name>ABC</object_name>
       <object_type>DATABASE</object_type>
       <parent_name>SYSTEMFE</parent_name>
       <parent_type>DATABASE</parent_type>
       <object_attribute_list>
           <map_to>NEWBAR</map_to>
       </object_attribute_list>
    </objectinfo>