Instructions for migrating the Crowd internal HSQDLB database to SQL Server

[Thomas Douglas]

Does anyone have any experience with migrating Crowd from it's internal database (HSQDLB) to a SQL Server instance? I would imagine there is an Atlassian document on it but I have not had any luck finding one.

Thanks, 

Byron Douglas

[Bruno Vincent · Accepted solution]

Hi @Thomas Douglas

Please follow these instructions: https://confluence.atlassian.com/crowd/migrate-to-another-database-180290495.html

(The procedure is the same for all databases, including HSQLDB)

[Thomas Douglas]

Thanks

[Mikael Sandberg]

Migrate to Another Database has the instructions to migrate the database.

[Thomas Douglas]

Thanks for this information! The document seems to outline migrating to a new server and migrating in the process. In my case, I'd like to upgrade my existing server, without changing anything other than the data store. Is there a way to change it without uninstalling and reinstalling my Crowd instance? It would be preferable if so

Thanks

[Mikael Sandberg]

It's been a while since I played around with Crowd, but I don't think you can do the migration from within the tool, so after you done the XML backup you can follow these instructions to Restart the setup wizard from scratch.

[Bruno Vincent]

@Mikael Sandberg is right, restarting from a fresh crowd.cfg.xml is the way to go.

@Thomas Douglas You might also want to read my answer to that very similar question: https://community.atlassian.com/t5/Crowd-questions/how-can-I-point-existing-crowd-installation-to-new-database-had/qaq-p/785912

[Thomas Douglas]

Thanks Mikael and Bruno, both of these links look like exactly what I need.