Can I change the database link?

Question

Hello Atlassian Confluence community,

I have a Confluence instance pointing to a database that will move to a new server:
Current link:

jdbc:jtds:sqlserver://current.mycompany.com/Confluence

Need to change to this:

jdbc:jtds:sqlserver://new.mycompany.com.com/Confluence

Unable to find this in the docs or online.  Is this even possible?  If so, how?

Thank you,

Tex

JP _AC Bielefeld Leader_ · Accepted Answer

Hi,

if the DB server is EXACTLY same version & the database is an EXACT copy and the DB server has the same security & db users, it going to work.

Try on a staging / test server before is always a good idea!

Best

JP

Nic Brough -Adaptavist- · Accepted Answer

To do this, you need to ensure the new database is an exact copy of the old one (i.e shut down confluence and then duplicate it), then you can edit the confluence.cfg.xml file to change the url.