If you are migrating a JIRA server to a new location, and as a result, the URL of the server changes, then you will need to manually repair some data in the database to make Enterprise Tester aware of these changes.

For the purpose of this article, we will assume that from and to URL's for JIRA are:

Before you Begin

Login to Enterprise Tester as an administrator, and configure the defect tracker link(s) being updated to all be disabled (accessed via the Admin tab).

Change the URL in each defect tracker to point to the new server and save, this will cause the details to be validated confirming the new server is accessible.

Stop IIS, from an Administrator command prompt on the Enterprise Tester server you can execute the following command: iisreset /stop

Backup your Enterprise Tester database.

Updating Incidents

Incidents within the Enterprise Tester database are stored across a number of tables. The table that needs updating when changing the JIRA URL is called "IncidentDetails", and in particular, a column called "TicketKey".

You will need the assistance of your DBA to run these queries against your Enterprise Tester Database.

Updating Requirements

For requirements synchronized to JIRA, the JIRA information is stored in a number of tables. As with incidents above, it is necessary to search and replace the values of the old server name with the new server name.

You will need the assistance of your DBA to run these queries against your Enterprise Tester Database.

Completing Process

Once you have searched and replaced all the data, execute SELECT statements across the tables you have updated and confirm the URLs have been replaced correctly.

We suggest running the following statement:

SELECT TicketUrl FROM IncidentDetails WHERE TicketUrl IS NOT NULL

Next, try some of the TicketUrl values generated within your browser to confirm that you get back the expected issue (to confirm the URL is not malformed).

Once you are happy with the data updates, you can follow these steps to bring everything back online:

Restart IIS, from an administrator command prompt, run the command iisreset /start

Login to Enterprise Tester (it may take a couple of minutes to start up).

Re-enable previously disabled defect links.

Try the following tests:

Create a new test incident in a project and confirm it synchronizes to JIRA in its new location correctly.

Update an existing test incident within a project and confirm it synchronizes to JIRA and has the correctly URL etc. when clicking on the external link displayed in top right corner of the edit incident window.

Please contact the Catch Team if there are any issues. Include details of all the steps performed and scripts executed and any other relevant information such as Enterprise Tester log files.