Skip to content

Clean up migration history

Migration runs and their per-record logs stay in the database until you remove them. Media Bridge registers both tables with the standard Business Central Retention Policy feature, so you can delete old entries automatically.

When to use this

The migration log has grown large, or your data policy requires old log entries to be deleted.

1. Prerequisites

  • You can set up retention policies (the Retention Pol. Admin permission set, or SUPER).

2. Steps

  1. Search for Retention Policies and open the page.
  2. Choose New and select the table:

    Table Date used for the age
    Media Migration Run (72539676) Started At
    Media Migration Log (72539677) Creation date of the line
  3. Choose a Retention Period, turn on Enabled, and close the page.

  4. Repeat for the other table if you want.

Media Bridge creates no policies by itself. Nothing is deleted until you set one up.

3. Recommendations

  • Deleting a run also deletes its log lines. A policy on Media Migration Run alone is enough to remove both.
  • If you set a policy on Media Migration Log too, keep its period shorter than the one for runs. A run with a very large log may otherwise exceed the maximum number of records a policy deletes in one go.
  • Don't delete the log of a run you still want to resume or retry. Resume and retry use the log to know which records are done. Without it, the records are processed again (pictures already in the target are skipped when Overwrite Existing is off).

4. Verify

  • After the retention policy has run, old runs no longer appear on Media Migration Runs.
  • Retention Policy Log Entries shows the deletions.