Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Feb 2005 @ 18:24:53 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Moving object between systems by using Teradata Administrator(WINDDI)
From:   Dempsey, Mike

The 'With data' option would not work when copying from one system to another. This would require either Archive/Copy (Restore) or another form of Extract/Load such as FastExport/Fastload.

Although it would be possible to add this feature if the copy was between databases on the same system there are no plans to do this. The current 'Copy' function works with all object types - not just tables. It works by issuing a SHOW command and then re-submitting the output after changing the database name prefix. In order to support the 'with data' option the copy of a table would have to be performed differently than other objects.

We have not received any requests for this functionality as far as I am aware - probably because the syntax to perform this function is easy for a DBA to enter themselves.

Mike Dempsey
Teradat Client Tools

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023