During the precheck phase, Data Transmission Service (DTS) verifies foreign key integrity constraints to prevent referential integrity violations in the target database.
When a child table references a parent table through a foreign key, both tables must be migrated together. If you select a child table as a migration object but exclude its parent table, DTS fails the precheck. Resolve the failure using one of the three methods below.
Method 1: Add the parent table
Add the missing parent table to the migration objects. This preserves the foreign key relationship in the target database and is the recommended option when both tables must be migrated.
Go to the target migration task and click edit task.
Click set whitelist and next in the lower-right corner of the page.
Select the required parent table and click > to add it to the selected objects.
Click precheck.
Method 2: Remove the child table
Remove the child table from the migration objects. Use this method only when the child table's data is not required in the target database — its rows will not be copied.
Go to the target migration task and click edit task.
Click set whitelist and next in the lower-right corner of the page.
Select the child table that failed the check and click < to remove it from the selected objects.
Click precheck.
Method 3: Remove the foreign key dependency
Drop the foreign key constraint from the child table in the source database. This lets you migrate the child table independently, but the target database will no longer enforce referential integrity between the two tables. Confirm this tradeoff is acceptable before proceeding.
Connect to the source database.
Run a command to remove the foreign key dependency from the child table that failed the check.
Run the precheck again.