I am at a client location when both VirtualCenter and Update Manager are not setup in an optimial way (i.e. SQL is local to VirtualCenter, and Update Manager is install on top of its). It is also an older version of VirtualCenter 2.5 that in need of update What I am trying to first (prior to separate the database from the local host is to uninstall Update Manager as cleanly as possible). I already uninstall Update Manager without any issue. However, I notices there are at least few tables that are still embedded in the current VirtualCenter Database.
Question Is there a sql script that I can run that would remove the unnecessary update manager database/tables from the current virtual center database? (when the original engineer who install this, he put both VC and UM on the same database). Or is this something I have to live with? Or can I remove the tables manually?
dwc