How to upgrade to Confluence 5.6.4 from 5.1.3

Question

Atlassian Support.  How do we upgrade to 5.6.4 from 5.1.3.  The 5.6.4 SQL database requires a different collation which means the normal upgrade procedures will not work, simply upgrading the app.

Do you have details instructions on how to perform this upgrade for a large Confluence instance?

Rodrigo Girardi Adami · Answer

this is a drawback indeed. I can recommend you to use in this case some third party database tool to change the collation of the database. In this doc, you can find the collation changer tool that might help in this case.

Cheers,

Rodrigo

William2 · Answer

Hello Rodrigo,

I believe I may have seen that article.  But we have a large confluence instance and I have read that performing an XML backup and restore is not recommended, possible data loss, which I cannot have.

Rodrigo Girardi Adami · Answer

Hi William,

You might be looking for this KB article.

Confluence must be using the SQL_Latin1_General_CP1_CS_AS as collation and also the net.sf.hibernate.dialect.SQLServerIntlDialect dialect in the confluence.cfg.xml before the upgrade to make sure that it will create the new datatypes.

I hope this helps,

Cheers,

Rodrigo