Migration Jira software and ServiceDesk from internal server to DMZ webserver

[Kildare_Clarke]

Hello Guys,

I'm fairly new the Jira universe and loving it. Let me get straight  to my questions

1. My current domain setup.....I and running Jira ServiceDesk 3.8.2 and Jira software7.5.1 on windows server 2012 r2 with SQL 2014 on a VMware VM. I do have my instance connected with AD so my end users can log in to their AD account to created ticket for the service desk and for software users to access their projects. The user's connection is not secured. they are able to connect based on my DNS entries to the server.
2. What I would like to do...... I would like to migrate my Jira ServiceDesk 3.8.2 and Jira software7.5.1 to a Windows Server 2016 ( Ie. the webserver in the DMZ making it secured HTTPS:// we already have a wildcard cert ) on a VMware VM But would like to migrate my SQL 2014 DB to PostgreSQL... I would also like to still have the ability for the user to login with there AD accounts. I was thinking we can user windows ADFS and also have the ability for users not on the domain create user accounts. Also, how would I tie trello into all this?

Any recommendation and directions would be much appreciated.

[Bhushan Nagaraj]

Hi Kildare,

Great to hear you are enjoying the JIRA Experience :)

Lots of questions here so let me try and break it down. I also highly recommend

- performing each operation as a discrete activity

- performing each operation on a test/staging environment, then implementing changes on the production instance

1. Migrate your database

Depending on the size of your instance, you should be able to use the XML backup and restore functionality to migrate your SQL database to Postgres. Refer to docs at https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html

2. Run JIRA behind a Proxy Server

You can choose Apache or IIS or any web-server of your choice. Refer to the docs at https://confluence.atlassian.com/adminjiraserver073/running-jira-applications-over-ssl-or-https-861253906.html

3. Run JIRA over SSL

Refer to the docs at https://confluence.atlassian.com/adminjiraserver073/running-jira-applications-over-ssl-or-https-861253906.html

4. Connect to a user directory

If you are using a Data Center instance, and have an identity management platform, you can use SAML authentication. You can also connect your JIRA directly to an AD server, or use Atlassian Crowd as the user management platform. Few choices here so invest some time to decide what best works for you longer term. Refer to https://confluence.atlassian.com/adminjiraserver071/connecting-to-an-ldap-directory-802592350.html

Hope that helps

Regards

Bhushan