How safely migrate Bitbucket to AWS

Question

We have Bitbucket DataCenter in our on-premisis with MSSQL DB. We have a plant to move AWS infrastructure.

Q1. Can someone suggest a best way to : Migrate existing MSSQL to PostgreSQL from its MSSQL backup file ( we do not want to directly migrate MSSQL to PostgreSQL as we need to keep the existing setup as it is).

I have googled but not a solid answer for this.

Q2. Then your suggestion needed for the migrated postgresql should be taken backup and restore to newly provisioned Bitbucket setup in AWS ?

Emily Chan · Answer

Hi @Kumar Duraisamy! I'm Emily, a product manager at Atlassian.

We've just built the beta of a solution to help ease migrations from Server/Data-Center-on-prem to Data-Center-on-AWS-Quickstarts.

Would you be interested to join our beta program and try out this solution? If you're interested, or would like to find out more, please email me at echan@atlassian.com.

Craig Castle-Mead_20fp9z · Answer

Hey Kumar,

Going back in my memory a bit, but I recall that Bitbucket had an inbuilt DB conversion that let us move from MySQL to psql. You mentioned you needed to keep running your current setup as well though, so suggest looking to stand up a full copy using MSSQL from a backup, then try the conversion option.

We've tried numerous MySQL >> psql conversion tools (for Jira) and none have been successful as yet. Bitbuckets database may be simple enough for these tools to work. I'd recommend https://pgloader.io/ if you were looking to try one though.

Keen to hear how you go.

CCM

Kumar Duraisamy · Answer

Thanks Steve, Will try this.