Recovery Insight database

Question

Hi Everyone,

I am trying to migrate my old Jira Server instance to the Jira Data Center. My currently version of JSoftware is 8.6. I have a big Insight database and after recovery from XML I have recovered all issues, project etc. but all Insight tables are empty.

I use Insight plugin 8.7.3 in old Instance. Would you know what's going on?

Oto Machaladze · Answer

Hi @jakub kalinowski ,

Using the add-on Insight Assets Backup & Migration you can migrate Assets (formerly Insight) object schemas to the destination Jira Cloud instance.

To read more details, please check the article below:

https://community.atlassian.com/t5/Jira-Service-Management/How-can-Assets-be-migrated-from-Jira-Data-Center-to-Cloud-or/td-p/2382324

Here you can see the full documentation for the application.

If you have more questions or suggestions feel free to contact Twinit support.

BR,

Oto

Hieu_jz6y9b · Answer

https://community.atlassian.com/t5/Jira-Service-Management/Insight-import-csv-from-Sharepoint/qaq-p/2181138

Maybe you can apply the solution from this post

Hieu_jz6y9b · Answer

Hi @jakub kalinowskiI don't do the migration yet, but I think you can do it manually likes:
- Check schemas of old insight.
- Backup only data related to insight.
- Restore all data from the backup of insight, then continue to check again

https://community.atlassian.com/t5/Jira-Service-Management/How-to-restore-Insight-from-DB-backup-without-affecting-Jira/qaq-p/1823355

Yes, I have worked with the internals of Insight in Jira, mostly for doing merges and migrations.  Not all of its data is held in those tables, there is data held in the Jira tables.

A simple restore of the insight tables will NOT restore all your data.

You will need to restore the whole backup you took into a temporary development system, work out what you deleted and then script a way to export and import it into the main system.

The answer from other post.