Archives of the TeradataForum
Message Posted: Thu, 02 Aug 2012 @ 19:15:56 GMT
<-- Anonymously Posted: Thursday, August 02, 2012 12:29 -->
TD 13 on Windows,
Suppose a database ABC has 100 tables with data in Production Server. The same database exists in Non Production server. I make a backup of ABC in Non production to a tape. Now I want to copy all tables of ABC from the tape to the target database, ABC in production server.
Does COPY command delete all data in the Target database and repopulate data?
Or should I delete all data in Target database first and run Copy command?
What does COPY command do when data already exists in the Target database tables?
Thank for your advise in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|