Archives of the TeradataForum

Message Posted: Fri, 29 Jul 2005 @ 16:27:51 GMT

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

<-- Anonymously Posted: Friday, July 29, 2005 12:26 -->

We are migrating data from our old test system to new test system (configuration is different) . We are setting up the archive/restore/copy jobs to do that.

I have a question on copying dictionary /DBC information to new system.

We are going archive DBC data tables and Dictionary information of all databases underneath the DBC using Arcmain as below.

We need the DDLs available to users on new system before we copy the actual data. Once the system is available to users, we are planning to copy data for each database using COPY statement.

There is no way for us to test the process. Are the statements below correct?

Archive of DBC/dictionary information (Old system)

     ARCHIVE DATA TABLES (DBC),
     RELEASE LOCK,
     FILE=ARCHIVE;
     ARCHIVE DICTIONARY TABLES (DBC) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;

Restore of DBC/dictionary information (New system)

     RESTORE DATA TABLES (DBC),
     RELEASE LOCK,
     FILE=ARCHIVE;
     RESTORE DICTIONARY TABLES (DBC) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;

Thanks

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