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.
system environment of the server: Linux, mysql