Friday, November 15, 2013

Storing Jetbrains TeamCity data in Microsoft SQL Server

One of the nice things that Jetbrains TeamCity offers that other 3rd party CI Tools such as CruiseControl.Net is the ability to store build data in an external database repository such as Microsoft SQL Server.

Of course, there are other supported database platforms, but for the purpose of this article, I will be focusing on only Microsoft SQL Server.

By default, Jetbrains TeamCity installs a local file-system based database, but if you are a large enterprise organization which needs to manage the database backups for disaster recovery of your build server, you will appreciate the ability to store this build data in an external database such as Microsoft SQL Server.

The details for setting up an External Database are provided here: http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database

It is advised to set up your external database at the same time that you first install Jetbrains TeamCity, however, if you have an existing installation of Jetbrains TeamCity and are interested in migrating your existing build data over to SQL Server, you can find instructions on accomplishing that here: http://confluence.jetbrains.com/display/TCD8/Migrating+to+an+External+Database


No comments:

Post a Comment