Database migration MSSQL to another MSSQL
Hi Jetbrains, all,
We are using Team City 7.1.3 with MSSQL and we need to migrate to another MSSQL database.
Is it possible to migrate the DB using the native MSSQL tools, and switch to the new DB by modification of the database.properties file?
I imagine the process as:
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
anyone has experience with this?,
thank you,
QAP.
Please sign in to leave a comment.
Hello,
it should be possible, the migration process (but with maintainDB tool) is more described here
http://confluence.jetbrains.com/display/TCD7/Migrating+to+an+External+Database
regards
Zdenek