Instructions for migrating the Crowd internal HSQDLB database to SQL Server

Thomas Douglas
Contributor
July 2, 2018

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

 

2 answers

1 accepted

1 vote
Answer accepted
Bruno Vincent
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 2, 2018

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
Contributor
July 3, 2018

Thanks

1 vote
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 2, 2018

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

Thomas Douglas
Contributor
July 2, 2018

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 2, 2018

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 2, 2018

@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
Contributor
July 3, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events