You can copy all tables and views from a source to a target database using ARC.
If a table to be copied already exists on the target, the target table is overwritten. If the target database contains tables that do not exist on the source or the tables are not being copied, those tables are maintained on the target.
Teradata ARC automatically copies statistics collected on all tables in the source database to the target unless the source Teradata Database version is earlier than 14.0 and the target version is 14.0 or later. In that situation, you must specify the copyStats attribute as true for each table with statistics that need to be copied.
- Open the parameters.xml file that has the job definition information for the job.
- Add the selection="included" attribute to the database element.
In the following example, all objects in the source database DBName are copied to the target:
<database selection="included">
<name>DBName</name>
</database>