Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 13:23:32 GMT

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

You can do a dictionary backup and restore of DDL only. not sure if this helps, because if you are copying specific tables from a database (and not all), you'd have to list each individually.

We run a backup of all DDL daily using the following code in ARC

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

I would think you can exclude the databases you don't want in this script, but you'd have to backup all DDL in the databases you leave in there.

Example: The following will backup DDL in all databases except database1 and database2.

     ,,,
     ,,,
     ARCHIVE DICTIONARY TABLES
           (DBC) ALL ,
           exclude (database1),
           exclude (database2),
     RELEASE LOCK,
     FILE=ARCHIVE
     ,,,
     ,,,

You can RESTORE to the dev system as follows:

     ,,,
     ,,,
     SCRIPT Restore
     LOGON $LOGON;
     COPY DICTIONARY TABLE
                 (databasenamex.tablenamex)  (from(databasenamex.tablenamex)),
     RELEASE LOCK,
     FILE=Journal;
     BUILD DATA TABLES (databasenamex.tablenamex),
     RELEASE LOCK;
     LOGOFF;
     ,,,,
     ,,,,,

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