Copy multiple projects from data centre to cloud for archive purposes

[Sarah Mathews]

The company I work for (company A) has acquired another company (company B). Company B uses Data Centre JIRA and has approx 70 projects. Company A uses JIRA in the cloud.

Company A wishes to take a copy of all of Company B's projects for archive purposes. All the projects must be read only on Company A's side (they will never be in production). Some of the projects may need to be accessed from time to time to view historical data, but most will never be touched (but we need to know we can access them if ever required).

Given we will never need to add data to these projects once they have been copied, what is the best method to do this? Should we use the Jira Cloud Migration assistant to copy everything from Company B to Company A's cloud site and then either hide the projects or make them read only? Or should we use Project Congfigurator? Or should we use offline archiving and only restore the projects when we need to access them? Or set up a separate site just for these archived projects? Or is there a better method in this scenario?

Any advice appreciated!

[Sloan]

Hi Kamil,

postgres should accept T, maybe try lowercase t 

Alternatively try active =1

or active ='true'

And are you positive cwd_user does not already contains users with the id 999999?

Do a select * on the involved tables to be sure. It never hurts to look "manually" with select * at a table.

Is there any way you can get Crowd up again and connected to your Jira? As long there were no changes to the config the Crowd directory should work again.

[Kamil Beer]

Hey Niklas,

thanks for your reply. It's pretty strange with 'T', as it even says that there is a numeric error. I will certainly try what you mentioned.

As for the 9999 user, we got the error from the db, so that's that.

We can get Crowd to run, but because of the migration, when we sign into the crowd console, we get a 404 apache error. So we can't go that way either... :/