Run the Pre-Migration Script | Teradata Vantage - 17.00 - 17.05 - Running the Pre-Migration Preparation Script - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Node Software Migration Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)

Download and install the latest PUTTools package on all TPA nodes.

DBC must have full access rights for DBC prior to archiving/restoring DBC. If DBC does not have full access rights for DBC, those right need to be granted prior to performing the archive. If the source system is not available, when DBC has been restored, you must explicitly grant full access rights for each object, view, and macro under DBC before running the post_dbc_restore script and DIP.

Run on the source system. The script performs a variety of checks for potential problems that must be resolved prior to continuing the migration process.

Each Advanced SQL Engine release has a unique subdirectory in the PUTTools directory for the pre-migration script applicable to that release. The folder is /opt/teradata/PUTTools/td17.xx.xx.xx/preupgrade/
  1. Create a temporary directory and change directory (cd) to that directory.
  2. In the temporary directory, run the perl command to start the script:
    perl /opt/teradata/PUTTools/td17.xx.xx.xx/preupgrade/ system_name/dbc,dbc_password output_filename

    The script generates output report files to the temporary directory.