Migrate confluence database from one SQL 2008R2 server to another SQL 2019 server

andy zhu May 20, 2021

What are the steps of moving the Confluence database from an existing SQL server (SQL 2008R2) to a new SQL server (SQL 2019)

Where does the SQL server connection information stored in the Confluence server?

 

1 answer

0 votes
Lei Wang
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 20, 2021

Hey Andy,

 

You can try to dump all the DB from SQL 2008 then import to SQL 2019. Please consult with your DB or contact Microsoft for further assistance.

You can check database connection information from Confluence System Information: <BASEURL>/admin/systeminfo.action

 

The database connection URL configuration will be in the <CONFLUENCE_HOME>\Confluence\confluence.cfg.xml. In Windows server, you may find it here: C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events