Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

BigPicture export/import

Hi everybody,

I shall export/import a Jira instance from a windows server to a Linux server. Which worked. In the meantime customer upgraded BigPicture to version 8.0.25 and now I get a syntax during importing a newly created backup file error on this command:


Which is an BigPicture table and obviously is the comma after the last field definition one too much.

Has anyone seen this already and was able to solve ? Probaby I've to go into entities.xml ?


2 answers

1 accepted

0 votes
Answer accepted
Adam _SoftwarePlant_ Marketplace Partner Jun 24, 2021

Hi @Norbert 

For problems like this, it would be best if you create a ticket to our Support Team so that we can investigate it further since it probably will require some investigation from our DEV teams. Please use the below link to create a ticket and we will be more than happy to help you with solving it!

- Support Portal



Hi @Adam _SoftwarePlant_

thx, I did so in the meantime and it was very helpful.


0 votes

Hi @Adam _SoftwarePlant_

we will probably be tasked with a similar todo in the future - to migrate from a Jira Server to a different Jira Server instance. Up to now I thought it would not be possible to export/import BigPicture data - but the thread here makes me think otherwise.

However, I was not able to identify the matching part in documentation. Could you please point me to the right direction?

The use case is to transfer/migrate all relevant projects from one instance to another (this is a well-known progress, no questions) and after that to ideally import BigPicture data so the users can continue using it alongside with all included data on the new instance right away.
Of course, we would make sure beforehand that all source and target versions are aligned.

Thanks in advance!

Hi @Daniel Ebers 

from my experience, if you move the whole instance from one server to another this shouldn't be a problem. If you're using on both systems the same database I would do it via database dump.

If you do it with a XML backup all data are included, also the BigData tables with content (stored in the AO_0456E7... tables)  We only had the problem with missing PK (which let abort the import) , which should be solved with version 8.1.  In the meantime there is a workaround editing the XML files.

I'm not sure if this works if you export/import single projects (I don't think so, but this I didn't test yet) .

Br Norbert

Adam _SoftwarePlant_ Marketplace Partner Jun 28, 2021

Hi @Daniel Ebers @Daniel Ebers 

As @Norbert has already mentioned, there should not be a problem migrating your BigPicture data from one Jira Server environment to another, as long as the database is the same.  However, we do recommend doing it via database restoration rather than XML, simply due to the lower number of issues with this kind of data migration.

In case you experience any sort of issue during the process, please open a ticket to our Support Team, and we will be very happy to help you with it.




Daniel Ebers Community Leader Jun 28, 2021

Thanks a lot, @Norbert + @Adam _SoftwarePlant_ 

My case will be a phased approach. Some projects will be migrated. Completely different databases.

The reply clarified it for me. The case from Norbert therefore was a different one.

Thanks again!



Adam _SoftwarePlant_ Marketplace Partner Jun 29, 2021

You are very welcome @Daniel Ebers 

Good luck and take care!


Suggest an answer

Log in or Sign up to answer

Atlassian Community Events