It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

DB migration from oracle to PostgreSQL Edited

In my organization we are using Oracle DB for Jira, We want to migrate the data from Oracle to PostgreSQL. If any one tried this migration, please help me to achive this. Please explain the practical challenges i can expect while migrating data from Oracle to PostgreSQL. Suggest any third-party tool to achive this.

note :We are using Jira Software 7.13.1

2 answers

Just another suggestion, if your JIRA isn't large enough you can try generating an XML backup from JIRA (which was connected to Oracle DB) and then restore the XML backup file on to another JIRA (with the same version) and could be connected to PostgreSQL DB. If this is successful, you can restore attachments & install add-ons. 

Please see this Atlassian article for more info:-

https://confluence.atlassian.com/adminjiraserver076/switching-databases-945110809.html#Switchingdatabases-differenttype 

-Shankar

0 votes

great article, really helps!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you