Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

db migration from oracle to postgre sql

soumyajit
soumyajit December 23, 2019

Background: Currently we are using Bitbucket v5.16.3 on our linux server with oracle db, but currently we want to migrate database from oracle to postgre sql with all data. Could you please guide me how we can achieve this.

Answer
Watch
Like Be the first to like this
604 views

2 answers

0 votes
Christian Glockner
Christian Glockner
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 24, 2019

Hi,

 

You can use the database migration wizard to move your database from one system to another: https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-an-external-database-776640378.html

Cheers,

Christian

Premier Support Engineer

Atlassian

View More Comments
Bhanu
Bhanu March 28, 2021

Is there a database migration tool for Jira other than the xml back up option.

Like
Reply
0 votes
Ganesh Babu
Ganesh Babu
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
December 23, 2019

Hello,

Just take a xml back up of the instance with oracle db, and later remove the dbconfig file.

Then restart the instance and connect to the postgre database.

Jira Version needs to be the same version as it was in the oracle db.

Reply

Suggest an answer

Log in or Sign up to answer
Bitbucket
Bitbucket
TAGS
AUG Leaders

Atlassian Community Events

    See all events