Pre-production Teamcity Server

Hi,

To avoid manual copy-paste configurations and all manual problems between a test TC configuration and the final configuration, we want to build a pre-production teamcity server.

The idea is to automate the synchronization between 2 TC servers.

But before trying to do this, I have some questions:

Does someone already try to do this ?
Can I just replicate the databases ? or should I take in mind some local configuration files ?

If I use maintainDB the export takes more than one hour and I the restore  .... a long time.
For nightly replication it could be usable but not for daily use.
So can I export only a minimal set of tables ? (for example table vcs_changes is not needed)


So, many questions perhaps some of you can give me a part of their experience.

Thank you
Mathieu

system environment of the server: Linux, mysql

5 comments
Comment actions Permalink

Hi,

TC has backup/restore feature. It actually stores its data under .Teamcity directory in user profile folder (if not configured differently) and in database. If you'd like to copy configuration from one server to another, you need to backup the configuration on the first server (http://confluence.jetbrains.com/display/TCD8/TeamCity+Data+Backup) and then restore on the second one (http://confluence.jetbrains.com/display/TCD8/Restoring+TeamCity+Data+from+Backup).

0
Comment actions Permalink

Thank you for the response.
In my case, this is not possible. The backup / restore takes too long time.

Can I exclude the table vcs_changes of the backup ? or restore ?
Because I don't need the history of vcs changes to test and it is the biggest table in the database.

Mathieu

0
Comment actions Permalink

You can choose what data to backup. There are several options here. You can completely omit the build history and vcs changes, if necessary.

0
Comment actions Permalink

Yes, maintainDB have many options, I can exclude logs for example.

But this works only in one way. From production to pre-prod TC server.
When my tests are ok on pre-prod how can I apply my changes on the production server ?

This to avoid, manual copy/paste and all possible missed or omissions.
I know and understand that it is not simple. It is a merge like vcs merge.

It could be a new feature for TC. ;)

0
Comment actions Permalink

TC stores projects and configuration information on disk under <userprofile>/.Teamcity/config/projects/. You can try to copy files on your own risk, but please mind the dependencies.

Meanwhile, copying/moving configuration is one of the upcoming features.

0

Please sign in to leave a comment.