Changing DB connection string for ALM projects

  • Questions
  • Changing DB connection string for ALM projects
Question ID: 106038

I have been tasked with correcting our ALM projects to point our database server which is having a DNS change. How do I best go about that as we have over 80 projects? I have been given a new path for jdbc:mercury:sqlserver to alter. Does this require dbid edit for all files manually?

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on April 28, 2015 2:56 pm
Answers (1)
Private answer


Yes to your question, you will have to manually edit the string for each project. However while you can edit the dbid to go about this, you can also instead just edit the connection string in site admin. NOTE: This will require each proejct to be deactivated when you change the string.

My suggestion would be to create a project list in excel and have a row for each project name. Have your new string in place there. This is a good check off method to ensure you don't miss any projects for edit.

In site admin, click on the Site Projects tab to see the full list of domains and projects. Click on a particular project to see the Project Details. Under this tab is the Connection string, which will match what you have: jdbc:mercury:sqlserver. Click on the blue Connection String to edit. You will be prompted to deactivate the project if it is not already. In new pop up window, you can change the string and it has a Test Connection to ensure it can communicate with the database. Click OK when done and your new string is present.

Many though as you mention prefer to edit the dbid.xml as best practice gives way to being able to backup each dbid.xml file as a precaution. That way you have the original settings in case of issue. The direct string edit can be copied too, so whichever method you choose. Deactivation or remove and restore with dbid would be needed as well to ''reload'' the project once the edits are done.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on April 28, 2015 2:58 pm
Never noticed the string in site admin. That is convenient. But I also see merit in the dbid as that is a better process to rule out mistakes. Though a good excel file populated in advance could be just as rewarding with less effort for the change. Appreciate.
( at April 28, 2015 3:00 pm)