Are there any tools to assist with database collation?

Question

Hey everybody,

We've been upgrading our Atlassian products over the last 9 months, and it seems like each time, there's a database collation step that involves significant work for our DBA team.  Are there any tools to assist with this or help speed up the process?

Shannon S · Answer

Thank you, Erik.

For SQL we officially recommend using the Management Studio to create the database at the time with proper collation. If you need to change it then we recommend this process:

* How to fix the collation of a Microsoft SQL Server JIRA database

Regards,

Shannon

Erik Stevens · Answer

Microsoft SQL Server

Shannon S · Answer

Hi Erik,

It depends on the database itself.

Could you let us know what type of database you're using so we could suggest something?

Shannon