Will the database on the new SQL server be a clone of the existing Confluence database?
If so, then it's just a case of stop confluence, edit the config file in the home directory that has the connection in it, restart it. I'd always recommend a re-index too, but it should not strictly be needed.
If it's not, then we'll need to know what you are trying to do in more detail!
The new SQL server will not be a clone of the current one. We currently have confluence pointed to an older SQL server that is going to be brought down, it houses our old electronic health record version and that environment will be spun down.
Therefore the need to point Confluence to a new SQL server and not one where our electronic health record resides.
Thank you for asking,
Great question. I didn't install Confluence ordinally and the guy that did is no longer on our tema. I am looking for guidance on what I need to do to repoint Confluence from one SQL server to another. So I don't currently have a preferred route, I really don't even know where to start. Are there some instructions for doing so?
Ok, makes sense.
Confluence is a system that uses a database (as a data store, not a real database, but that's not too important here). Take the database away, you lose everything you've put into Confluence.
So. If you want to change the database that Confluence is using for its datastore, you need to think about how to move the data from the old one to the new.
It's not as simple as a "repoint" - repointing just means telling a system to use a new database, but if you do that with any system, you're telling it to stop using the data you have in the old database. Which means you are starting afresh and you lose all the old stuff.
There are broadly two ways to move (copy really) data from one place to another so that Confluence keeps everything:
So, the next question is how different the old and new SQL servers are. If they're similar enough, I would very strongly recommend you get the DBAs to do the work - export, copy and import the database wholesale.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events