15.11 - Copy and Restore Definitions - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Data Stream Architecture
December 2016
User Guide

The difference between copy and restore depends on the operation being performed.

A restore operation moves data to one of the following locations:
  • From archived files back to the same Teradata Database from which it was archived
  • To a different Teradata Database if the DBC database from the source system is already restored to the destination system

A copy operation moves data from an archived file to any existing Teradata Database and creates a new object if the object does not already exist on that target database.

You can copy an object to create a new object with a different name, or keep the same name as the source object. In database-level copy operations, you can copy to a database with a different name or maintain the same name as the source.