Hi,
I have about 20 TFS 2013 repositories.
I'm going to upgrade to TFS 2017.
anyone knows how to update tfs version within the Postgres database instead of update each repo one by one ?
and of course, if that way is safe ?
Hi Zvika,
If you are using the bundled PostgreSQL database, the following SQL statement will change the TFS version as required.
UPDATE public.builds_repositorydata SET plugin = REPLACE(plugin, ‘TFS2013’, ‘TFS2017’) WHERE plugin like ‘%“TFSRepositoryPlugIn”%’;You can run this using the Query Tool in pgAdmin3 (%ProgramFiles%\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin\pgAdmin3.exe).
You will find connection details in %ProgramFiles%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config under //
Ensure that you have a backup of the database before running any SQL statements so you can recover from any mistakes. Also, shut down and restart the Continua CI Server server after running otherwise cached values will be used by the service.