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.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events