I'm migrating Bitbucket 7.8.0 database from one MS SQL server to another.

Question

I'm migrating Bitbucket 7.8.0 database from one MS SQL server running MS SQL 2016 to another running MS SQL 2019. I'm not seeing any instructions on how to do this. Are there any other steps other than changing the config file to point to the new server?

Christian Glockner · Answer

Hi,

From the Bitbucket Server side nothing else is required, assuming you're taking care of the SQL Server side of things (i.e. moving the DB to the new server). You can also use the Database Migration Wizard in Bitbucket Server to move the data over, provided you have the connection details and empty database on the destination server.

See https://confluence.atlassian.com/bitbucketserver/connect-bitbucket-to-an-external-database-776640378.html

Cheers,

Christian
Premier Support Engineer
Atlassian

Robert Wen · Answer

I'd take a look at the Microsoft documentation.

https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide?view=sql-server-ver16