Crowd migration to the new server but staying with existing database

Hello,

we are migrating crowd to the new server, but we would like to keep existing database with existing data. Problem is that while setting up Crowd on the new server according to steps described on the page https://confluence.atlassian.com/display/CROWD020/Running+the+Setup+Wizard on the step 3 we get error "Database contains existing data" and cannot continue to finish the installation.

I would like to ask what is the standard way to migrate crowd to the new server but keep existing database connection. Or is it necessary to export data from the database to xml file, then overwrie data during Crowd setup on the new server and import data back to the database?

Thank you

2 answers

1 accepted

Hi Mato,

Yes we definitely recommend using the XML backup to store and restore your user Data when moving between servers. This will allow Crowd to properly set up everything for the new server/location then import the data over it.

We have a guide about this - Migrating Crowd between Servers which goes into more detail about migrating Crowd Data. As there are a few steps to take before making the backup.

Cheers,

Ivan.

Hi Ivan,

thanks for quick response.

Regards,

Mato

Unfortunately, https://confluence.atlassian.com/display/CROWD/Migrating+Crowd+Between+Servers does not describe using the XML backup to store and restore your user Data when moving between servers.

Hi Ivan,

My database server has been crashed, and i didn’t get chance to backup my data as xml backup, but fortunately i was able to get backup of my JIRA database.

I restored my database on a different server and connection made was successful as done by "JIRA Configuration Tool".

JIRA started but asking me to create new admin.

After doing so, when i logged in by new admin it shows me no existing users, no issues and nothing although data is present in database. Also my database schema is same "dbo" as it was before.

Can please guide how to connect existing database without xml backup.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

942 views 5 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot