Previous Topic

Next Topic

Inhoudsopgave

Book Index

Tables runs and errors

All data of a migration are related to a migration run. Therefore, all tables have a foreign key to the runs table.

ANSI: 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;