Migration Timetable - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
heq1467819788761.ditamap
dita:ditavalPath
5942_Migrating_1510.ditaval.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software

Planning and performing a migration is a complex process requiring many activities to ensure that all the required software and information has been gathered.

All migrations are performed under the guidance of Teradata Customer Services staff, who work with you to develop a plan for system migration. The key to a successful migration is preparation.

Prior to the scheduled day of migration the following steps should have been completed:
  • Download all necessary documentation.
  • Install latest PUTTools package on system.
  • Run the Pre-Upgrade Preparation script to identify and fix any problems.
  • Prepare the destination system if different from the source system.
  • Install the desired software release, including the latest Teradata Tools and Utilities.

The time required to complete a migration will vary between systems. The most time consuming step is the actual transfer of all of the data from the source to the target system, so the migration will take at least as long as it takes to perform a full system backup.

If changing the row format from packed to aligned, or from aligned to packed is part of the upgrade, it will most likely take at least twice as long as a full system backup, because every data row must be rewritten field-by-field, one row at a time.

After all of the data has been migrated to the target system the remaining steps and system validation will also vary, depending on the size of the system and the types of data objects. You can use the upgrade estimator to get an idea of how much time will be required.