The number of project versions in TX gets large quite fast. With thousands of versions, the TX application and projects tend to open and execute slower for each version.
Cleaning out this log without having to delete all versions would be nice. Either by allowing deletion of a selected number of “old versions”. Or even better, set a “project retention” setting to keep only versions for the last 12 months or so.
Today this process is cumbersome with multiple steps like:
- Backup the repository database
- Open the project and export it to XML
- Close the project
- Create a new empty repository
- Run a set of SQL queries on the repo in order to copy Environments and Global Databases.
Drawbacks of this is:
- You loose ALL versions
- Manual step is prone to errors
- Risk of repo becoming corrupt if something goes wrong
Since the TX applicaton and executions runs a lot slower with big repos, this cleanup process should be included as standard functionality.
