Importing Audit data from another system

[matthieu-delisle]

Hello,

We are about to migrate an old system that has audit tables, but structrured differently than the audit table from the bundle. We have 2 possibles solutions :

1. We use our API to run every line of audit table through and find a way to put the real date that the action happened.
2. We use migration tool with the help of SQL query to import the data, but the challenge is to populate the diffs field properly.

Is there anyone who did anything of the sort? Is there a best practice?

Thank you