Database Migration - Insight

Question

Hi,

I'm trying to migrate Jira's database from Oracle to SQL Server.

I've correctly do the migration using the XML Backup Tool, exporting the file and importing in the new instance (following the oficial documentation step by step).

I thought that the XML Backup Tool export all the information, but when the new instance was started I realized that the Insight configuration (schemas and objects) was empty.

Then I found a Export tool by Object Schema in Insight. I exported the zip for each one, but when I tried to import in the new instance, I got the same error for each zip file.

Start importing object schema and objects, object schema id: 1
[insight-InsightThreadGroup-worker-thread-8] | Unable to insert object type ObjectTypeBean [id=5895, name=Estruturas Organizacionais] will skip this object type, Error: Index: 0, Size: 0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.rangeCheck(ArrayList.java:657)

José Ignacio Durand · Answer

When you export the data from JIRA, a zip with two XML files is created. And when you import that file in the new JIRA's instance, first the file with the object schema for JIRA is imported (from 0 to 90% of importation progress). Then, the second XML (with the object schema of all the plugins) is imported (from 90 to 100% of importation progress). In my case, the second file was wrong, creating and SQL Server error during the creation of the tables). But, because the first file was imported correctly, when Jira restarted after the error in the import process, the new instance was working fine, just the plugins info was missing.

Pay attention to that. See the logs created during the import process and you'll find the exact error. In my case, a plugin had a bug, so I had to edit manually the second XML (following the recommendations of the plugin's support).

Suhas P · Answer

@José Ignacio Durand  Did you manage to fix this? I get the same error while importing Object Schema. I migrated from MySQL to MS SQL.

Alexandra Zayceva · Answer

A possible option to migrate from Oracle to MS SQL Server is a customizable tool that transfers database objects and data to target platform. Migrate Oracle to Microsoft SQL Server automatically.