Is there a way to "undeploy" projects? (i.e. remove projects from the server after they were deployed). How about individual project components (Operations/Transformations/Sources/Targets/Web Service Methods/etc)? Can they be "undeployed" individualy? Is it possible to see what operations/transformations/etc are deployed to a particular server?
At this point I'm pretty much convinced that in a current release (1.1) none of the above can be done through the UI but I don't mind doing this by querying/updating database directly. The problem is that due to the lack of declarative referential integrity constraints, it's not that easy to figure out what the relationships/interdependensies between the tables are.
For example, it looks like to "undeploy" the transformation, one can delete corresponding data from TranDB.transformationstab_new and TranDB.transformation_definitionstab tables but is it enough? Are there any other tables that should be cleaned up?
So, I guess my question is, could somebody provide a list of tables that one can
a) use to see what project components are deployed to a particular server
b) delete data to "undeploy" specific operation
c) delete data to undeploy specific transformation
d) delete data to undeploy web service method
e) delete data to undeploy text structure
f) delete data to undeploy source
g) delete data to undeploy target
Any other method that can be used to achieve the same results would be great too, of course.