You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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:
CREATE TABLE public."AO_0456E7_T_CORE_FIELD_VAL" (
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 ?
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!
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!
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) .
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.