A number of scenarios exist in which tables and databases in a job continue to be copied after a table or database copy fails.
Utility Used | Objects Copied | Scenario | Result |
---|---|---|---|
TPTAPI | Tables | Table has an incorrect column name in its WHERE clause | Table copy fails. Job continues and the remaining tables are copied to the target database. |
TPTAPI | Tables | Source user does not have SELECT access to one of the tables | Table copy fails. Job continues and the remaining tables are copied to the target database. |