Space Migration (server) between confluence instances

[Aarthi Pillai]

Hello All,

I am migrating some spaces from A instance to B instance (via Full XML import and export)

My Question : is there any Post-migration checks available ( Apart from the message that is displayed on the screen which shows 100% completed message)

we want to make sure all the attachments, pages, is migrated 

Any automation, plugin etc we can check the same?

Thank you for your assistance

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hi @Aarthi Pillai ,

welcome to the Atlassian community!

I did it in the past. My suggestion is to run some queries at db level in order to check :

• number of pages per space

• select count(c.CONTENTID)
  from spaces s
  inner join content c on s.SPACEID=c.SPACEID
  where c.CONTENTTYPE='PAGE' and s.SPACENAME='YOUR_SPACE_NAME_HERE';

• number of attachemnts per space

• select count(c.CONTENTID)
  from spaces s
  inner join content c on s.SPACEID=c.SPACEID
  where c.CONTENTTYPE='ATTACHMENT' and s.SPACENAME='YOUR_SPACE_NAME_HERE';

It should be the best way to perform this double check.

Fabio

[Aarthi Pillai]

Thank you Fabio 😀 

yes for checking pages, attachments we can run queries to cross verify 

but what about the data contents in it? 
Eg when I have migrated the space in target instance, all the pages and attachments are present 

But the page is showing older contents in the target instance and also that page is showing the correct last edit date 

whereas, in source instance we have the latest data 

(This has happened only with one 1 page) 

Any ideas ?

[Fabio Racobaldo _Herzum_]

Hi @Aarthi Pillai ,

it's very weird. Try to perform a new export from the source instance and to import that space only from scratch in the target instance in order to verify.

[Aarthi Pillai]

Hello @Fabio Racobaldo _Herzum_ 

This issue was due to collaborative editing feature, which is now resolved.

Thank you for you assistance :) 

[Aarthi Pillai]

Your*

[Fabio Racobaldo _Herzum_]

Good! Please mark my answer as accepted so this thread can be considered closed