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.

1 comment
Comment actions Permalink

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

0

Please sign in to leave a comment.