How to use Data Mover to migrate data to another TD AMI

Teradata Database on AWS
Teradata Employee

How to use Data Mover to migrate data to another TD AMI

I am trying to use a Data Mover EC2 instance to move data from one TD instance to another TD instance. I have successfully launched a Data Mover image, but I have no idea how to configure this thing. Can anyone help?

Tags (2)
1 REPLY
Teradata Employee

Re: How to use Data Mover to migrate data to another TD AMI

For configuring your Data Mover instance, please refer to this document: http://www.info.teradata.com/HTMLPubs/AWS/wwhelp/wwhimpl/js/html/wwhelp.htm#href=ConfiguringTeradata...

After you have configured your Data Mover, you can follow the steps below to run a sample job.

  1. Make sure that the database is up for your source, target, and the Data Mover system.
    • Checking the status of database:
# sudo su -
# pdestate -a
  • Starting the database
# sudo su-
# service tpa start
  1. Log on to the Data Mover system and run these commands:
# sudo su -
# cd /tmp
# mkdir datamover
# cp /opt/teradata/client/15.11/datamover/commandline/samples/* /tmp/datamover/
# cd /tmp/datamover/
  1. Inside the /tmp/datamover directory, open create.xml with a text editor and modify the following fields:
    • job name (something unique)
    • source_tdpid
    • source_user
    • source_password
    • target_tdpid
    • target_user
    • target_password
    • database name
    • table name
      • You may add more than one table
    • For example:
...
<job_name>MyJob1</job_name>
<source_tdpid>123.456.7.8</source_tdpid>
<source_user>mySourceUser</source_user>
<source_password>myPassword</source_password>
<target_tdpid>234.564.45.7</target_tdpid>
<target_user>myTargetUser</target_user>
<target_password>myPassword</target_password>
...
<database selection="inselected">
  <name>myDatabaseName</name>
  <comapre_ddl>true</compare_ddl>
  <table selection="unselected">
    <name>myTableName</name>
    <comapre_ddl>true</compare_ddl>
  </table>
</database>
...
  1. Run the following commands:
datamove create -f create.xml
datamove start -job_name [job name]
  • replace [job name] with your job name defined in create.xml
  1. If you want to check the log, you may access it by running the following command:
datamove status -job_name [job name] -output_level 4