How safely migrate Bitbucket to AWS

[Kumar Duraisamy]

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]

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]

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

[Steve Thornhill]

Have you looked at the options provided here - https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL

There are several database migration tools available if you wish to convert the data and restore this way.

[Kumar Duraisamy]

Thanks Steve, Will try this.