Archives of the TeradataForum
Message Posted: Thu, 20 Nov 2003 @ 11:24:21 GMT
I am after a way of replicating lots of databases from one Teradata machine onto another but not transferring the actual data just the DDL. The idea is to allow our developers to get their code syntactically correct before we allow them loose on the data.
Is there a way of getting ARC to restore/copy the database but not the data - I am thinking along the same lines as the create table as command that just creates the DDL if you do not specify WITH DATA.
If this not a goer then is it best to try to rebuild the tables from DBC.Tables. Does anyone have a script up their sleeves and does restored data, alter table commands and secondary indexes impact on this approach - anything else?
Ian A Russell
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|