Data migration with changing the collation of our Ms-SQL database from "SQL_Latin1_General_CP1_CI_AS

Hello Team,

We have JIRA database in Ms-SQL format and we want to upgrade JIRA version from 7.0.10 to 7.3.6
We have upgraded the JIRA on test server without any problem but after the upgrade the JIRA health check shows warning about the collation.

So right now we are planning to chnage the collation of our Ms-SQL database from "SQL_Latin1_General_CP1_CI_AS" to "SQL_Latin1_General_CP437_CI_AI".
We have already follwed the steps which is on the URL " https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-microsoft-sql-server-jira-database-776646810.html "
The database size is 4GB and so it took more than 24 hours to migrate the data from one database to another.

We do not take the downtime more than 5-6 hours on our production JIRA server.
I want to any other method or steps, so we can migrate data with correct collation within minimum time. 
Please provide us some other methods or steps to complete our task.

Thanks!

1 answer

This widget could not be displayed.

Hi Dnyaneshwar,

Regardless of the method you use the amount of data is going to cause the slowdown, however, that does seem like a long time.

  • Do you see any errors in your logs that could indicate errors during the migration?

The process might be slow, due to insufficient resources on your machine due to the fact importing data requires a lot of resources. I would recommend checking the resources allocated for your JIRA instance during the importing process to check whether they are enough and the disk is not running our of resource in that process.

Review the JIRA Sizing Guide and make sure you have the recommended resources allocated to JIRA. 

Again, be sure to review the logs and see if you can isolate any messages that would indicate a slow import and post the snippet and we'll go from there.

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

573 views 25 15
Join discussion

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