Archives of the TeradataForum
Message Posted: Sun, 23 Nov 2003 @ 13:41:04 GMT
Subj: | | Re: Restoring just DDL |
|
From: | | Andrew Schroter |
I have run into some problems with WINDDI copying objects when the object being copied is a table definition with massive use of Mulit-
Value Compression. The WINDDI utility will occasionally drop a character and the resulting copied object doesn't create properly due to the
missing character. In my experience it's always in the middle of one of the compression candidate statements.
Also I have run some informal benchmark comparisons of using WINDDDI and ARCMAIN. WINDDI set up is much quicker, but ARCMAIN is much
faster for copying, restoring, and building the new objects when hundreds or thousands of objects are involved.
Andy Schroter
|