I have several different projects and all of them currently hardcode server names, DB user and passwords.
I have found all of the places that need to be changed in order to point to a new server, but there are at least 50 instances where the same change is required, which looks like terrible design.
I would like to change this so that this information is centralized so no one else would have to go hunting for this again. I have read about setting environment variables, but preferably I would like to include the information with the projects themselves such as reading from some sort of configuration file.
How should I approach this?