...
Before you Begin
Before making any changes we suggest that you:
- 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".
...
Database Type |
|
Sql Server | UPDATE IncidentDetails |
Oracle | UPDATE INCIDENTDETAILS |
MySql | UPDATE IncidentDetails |
PostgreSql | UPDATE IncidentDetails |
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.
SQL Server
ExternalSystemReferences | UPDATE ExternalSystemReferences SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/') WHERE ExternalUrl IS NOT NULL |
ExternalIconUrl | UPDATE ExternalSystemReferences |
ExternalStatusIconUrl
| UPDATE ExternalSystemReferences |
ExternalStatusIconLink
| UPDATE ExternalSystemReferences |
Oracle
ExternalSystemReferences | UPDATE EXTERNALSYSTEMREFERENCES SET EXTERNALURL = REPLACE(EXTERNALURL , 'http://jirasvr/', 'http://mycorp.com/jira/') WHERE EXTERNALURL IS NOT NULL |
ExternalIconUrl | UPDATE EXTERNALSYSTEMREFERENCES |
ExternalStatusIconUrl
| UPDATE EXTERNALSYSTEMREFERENCES |
ExternalStatusIconLink
| UPDATE EXTERNALSYSTEMREFERENCES |
My SQL
ExternalSystemReferences | UPDATE ExternalSystemReferences SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/') WHERE ExternalUrl IS NOT NULL |
ExternalIconUrl | UPDATE ExternalSystemReferences |
ExternalStatusIconUrl
| UPDATE ExternalSystemReferences |
ExternalStatusIconLink
| UPDATE ExternalSystemReferences |
PostgresSQL
ExternalSystemReferences | UPDATE ExternalSystemReferences SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/') WHERE ExternalUrl IS NOT NULL |
ExternalIconUrl | UPDATE ExternalSystemReferences |
ExternalStatusIconUrl
| UPDATE ExternalSystemReferences |
ExternalStatusIconLink
| UPDATE ExternalSystemReferences |
...
Database Type |
|
Sql Server | UPDATE ExternalSystemEvents |
Oracle | UPDATE EXTERNALSYSTEMEVENTS |
MySql | UPDATE ExternalSystemEvents |
PostgreSql | UPDATE ExternalSystemEvents |
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.
...