Reconciliation after Mantis migration

[Deleted user]

We are migrating our entire Mantis database to Jira, we have used Mantis for the past 8 years or so we need to ensure everything as come over safely and correctly.

Does anyone have anyway of performing a reconciliation in both databases to ensure the data matches?

It may be worth noting im very confident that everything has come over in one peice, we have spent a lot of time doing trial runs. But this is paper work that is required for audit purposes.

[Timothy · Accepted solution]

The way I would suggest is to match them at the database level. Creating SQL scripts would be the fastest way to achive your goal.

[codelab expert]

I agree with Timothy. 3 years ago we migrated from Mantis to JIRA. I created a lot of SQL statements to ensure that all is fine!