Rename a Database | Command Line | Teradata DSA - 17.20 - Renaming a Database - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2022-11-14
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
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 destination 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>