All data of a migration are related to a migration run. Therefore, all tables have a foreign key to the runs table.
The migration run creates a record in the runs table with both the database name of the database to be migrated and the remark you have given to the run. The start_run field will be assigned the system data by default. At the end of a migration, the system date will be applied to the end_run field.
The migration run stores all errors and warnings that occur during a run in the errors table.
You can use the stored procedure drop_run to remove all data of a migration run. This will remove the migration data from all tables in the ANSI_Migration database.
Example:
execute
dbo.drop_run @RunId = 13;