Rename Tables | Teradata Data Mover - 17.10 - Renaming Tables - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
You can rename one or more tables on the target when you copy an entire database.
  1. Open the parameters.xml file that has the job definition information for the job.
  2. Under the database name, add the selection="included" attribute to the table element.
  3. Add a name element and enter the current name of the table.
  4. Add a target_name element and specify the new name for the table.
In the following example, the DBName.Orders table is renamed to DBName.Orders_Newname and DBName.Accounts is renamed to DBName.Accounts_2 on the target.
<database selection="included">
<name>DBName</name>
		<table selection="included">
			<name>Orders</name>
			<target_name>Orders_Newname</target_name>
		</table>
		<table selection="included">
			<name>Accounts</name>
			<target_name>Accounts_2</target_name>
		</table>
</database>
You can specify a staging database for the table to be renamed. In the following example, the DBName.Orders table is copied to the stage1 staging database and renamed to stage1.Orders_Newname.
<database selection= "included">
	<name>DBName</name>
		<table selection="included">
			<name>Orders</name>
    <staging_database>
     <name>stage1</name>
		  </staging_database>
    <target_name>Orders_Newname</target_name>
		  <staging_database>
  </table>
</database>