Moving workspace from one repository to another

I reckon you could build something to automate it with the Repositories REST API....

OR (use this at your own risk - unsure of any flow on effects)

Access the underlying FME database and change the 'repositoryinfo_id' field in the 'fme_item' table for the required workbench to the matching ID of the repository (found in 'fme_repositoryinfo')

JobHistoryStatisticsGathering usually is under 'Dashboards' repository, by changing the ID to '1' it moves to the sample repository.

You'll then need to movethe workbench folder from the old repository folder to the new one. In this example on my local machine:

move this folder - D:\\ProgramData\\Safe Software\\FME Server\\repositories\\Dashboards\\JobHistoryStatisticsGathering

to here - D:\\ProgramData\\Safe Software\\FME Server\\repositories\\Samples\\JobHistoryStatisticsGathering

I don't know the exact number, but it's only a handful. Probably best to tackle this when they want to move to FME Server 2020 and do a fresh start. There's some other stuff they've done that I'd like them to change.

I looked at the REST API and came to the conclusion it can't be used to upload workspaces 😕

And in this case I'd be very weary to edit the database directly. Given that this is for a relatively small number of workspaces I think the risk of something unforseen going wrong is too high and the potential time savings don't warrant it. As I mentioned in my reply to @virtualcitymatt​ above it looks like a fresh start when they do an upgrade is the best way to go.

It's good to know the option of editing the database exists, but I'd only use it as a last resort.

Yeah nice - if its only handful then it will be a good opportunity to test everything and check that all is in order, republishing will be minor compared to testing.

Hi Hans,

I actually did something like this in the past with the REST API, I am quite sure this can be done with the API.