DB Migration from MSSQL to MSSQL
Hello There,
I have read the post about Migrating TC DB from one DB Host to another and the process described is as follows....
1) shut down the TC server
2) migrate the MSSQL DB using it's native tools
3) modify the database.properties file to point to a new location
4) start the TC server
I have a couple of questions with regards to our setup...
We have 2 servers.
One server is Running the TC Server (website) and it has 2 separate build agent services running
The other server is simply running 2 build agent services
It appears that there are no settings with the build agents that define the Team city Database
1) I'm assuming that the TC Server handles all database tasks and it simply issues commands to the build agents?
2) I'm also thinking that there is only one database connection defined in the entire setup?
The TeamCityService points to ....
C:\TeamCity\bin\TeamCityService.exe
In
C:\TeamCity\conf\teamcity-startup.properties
The following is defined...
teamcity.data.path=D\:\\ProgramData\\TeamCity
In
D\:\ProgramData\TeamCity\config\database.properties
The following is defined
connectionUrl=jdbc\:sqlserver\://AUCOLO-TFS\:1433;databaseName\=BuildServer_TeamCity;integratedSecurity\=true
3) Is this the only connection I need to change to point to the migrated Database?
Kind Regards
Bill
Please sign in to leave a comment.
Hi Bill,
Your assumption is correct. Build Agents don't access directly the database, all accesses to it are handled on the server. Also correct, that the database.properties is the only connection definition to the database. This file is also pointed out in the database migration documentation.
If you face any issue, please don't hesitate to ask.