We have one server that has the TeamCity application. Another server has the external database on there. This machine is getting old and needs to be retired. We have a new server for the database.
The only thing that will be moving is the external database, not the application itself.
The documentation I have seen talks about moving to an external database and all of these other methods that just doesn't make sense.
Can't I just do this:
1. Stop the TC services
2. Take the current database on "DB server one" and drop it from the server. Copy the two database files over to the new server and attach it on "DB server two".
3. Open the "database.properties" file and modify the line from:
4. Start up all of the services.
I would think that this would work fine. I searched the entire directory structure for DBSERVER1 (not the real name) in every file and other than log files and xml files from builds, the "database.properites" was it. I believe that changing that to DBSERVER2 (again not the real name) and leaving the application untouched, this should be fine moving the database to a new server.
Thoughts? Concerns? If I am incorrect, please let me know what I need to follow in the help section to accomplish this.