I want export workflows from one galaxy instance(old) to another galaxy instance(new). Many tools are locally developed and installed from local galaxy toolshed in old galaxy instance. In the new galaxy instance, new local toolshed IP/address is different. So the tools installed from local toolshed has different id (e.g. old ids 10.xx.xx.xx/aa/bb/. new ids 128.xx.xx.xx/aa/bb/).
And, I have copied the workflows to new galaxy instance.
Now, due to different tool Ids, even though the tools are there in the new galaxy, the workflows are complaining about "missing tools".
Basically, I have to replace the old address by new address in the backend.
There are so many tables in postgress. I checked/tested some of the tables and it doesnt work.