Migrate from embedded mysql db to ms sql external db

[NinjawithPyjamas]

Hello,

I am struggling to find steps on how to take my data in my current embedded DB and export it to a new MS SQL DB (external) ... Anyone have the steps

[robert.nadon]

Hi @NinjawithPyjamas ,

(Love the user name BTW). There are published atlassian guides on migrating a database.

https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

Some of the things to consider are if this database is used for other things outside of jira, making sure  you are running a supported database (see supported platforms (https://confluence.atlassian.com/jseng/supported-platforms-881686453.html) and above all make sure you have a tested backup to roll back to if things do not go as planned, and they rarely do.  

We can help along the way if needed too, here @Appnovation with various offerings from having us do it for you, to simply joining a web conference in case you get into trouble.

Hope this helps,

Robert

[NinjawithPyjamas]

Do i need to remove the dbconfig file or can i just import the XML thru the "new" Jira Admin page ?

[robert.nadon]

Please make sure you have a good backup of everything, then yes removing the dbconfig.xml file (to make things easier for rollback I usually just move it out of the Jira HOME) will prompt jira upon boot/restart to connect you to your new database, and  will recreate the dbconfig file for you.  The dbconfig file will setup the database connection, does not have anything to do with the import.  

Please note when setting up a new database in the MS SQL (or really any database) please make sure you have set the proper collation. 

[NinjawithPyjamas]

I am standing up a vanilla instance so the MS SQL DB will be connected and empty - well apart from the admin account i guess

So i just need to export XML from current and then restore (import) in to new right?