The following applies when copying an entire database:
- You can copy all tables and views from a source to a target database using Teradata DSA.
- If copying a table that 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. The exception is when using DSA to copy data to a target database with a version earlier than 16.20, in that scenario the tables are deleted.
- DSA automatically copies statistics collected on all tables in the source database to the target database.
Full databases from newer to older versions of Teradata Database cannot be copied. This is a restriction with DSA and other utilities that an entire database cannot be moved. Teradata recommends that the user must upgrade the target database to a newer or same version as the source database. If upgrade is not possible the alternative solution is to utilize other available utilities to move objects individually.
- 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>