What I intended to do was to copy a database from one instance to another this way:
- 'alter table nocheck constraint all' on every table
- 'truncate table' on every table, to make sure that no data from before DTS-copying can be left.
- DTS (which replaces data, not appends)
- 'alter table check constraint all' on every table
However, I now realized Truncate Table requires the Foreign Keys to be dropped, disabling them through Nocheck is insufficient.