Can I change the database link?

[tex.clark@gettyimages.com]

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

[Nic Brough -Adaptavist- · Accepted solution]

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.

[JP _AC Bielefeld Leader_ · Accepted solution]

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

[tex.clark@gettyimages.com]

Jan-Peter and Nic,

  Confluence is working now.  Turns out that yes, you can point Confluence to another database.  That was the first question.  The second question was how to do that.  The answer is to edit the confluence.cfg.xml file to change the destination.

Then, the new DB has to be exactly the same.  However, in this situation the DB moved from SQL on a Windows 2008R2 to Windows 2012.  As a result, "allow 2008r2 database compatibility" also has to be enabled/configured on the DB server.  Also, the "make the login on new server fully the same as on old" also has to be enabled/configured.

The database stuff is more than I know, just repeating what I heard.

Bottom line is that Confluence is now working on the new database.

Thank you both for the response- pushed me in the right direction.  Much appreciated!

Tex