Would anyone have a complete list of the ALTER TABLE xxxx DROP COLUMN xxxx statements that are executed by running the MDM to upgrade to 7.5?
There are some legacy jobs implemented by the DBAs a long time ago that were running against the database which created statistics. Therefore when I run the upgrade and one of the drop column statements is executed against a column that is referenced by a statistic the MDM errors. I then have to restore the database, drop the statistic causing the issue and re-run the MDM. I have done this around 10 times and it's getting a bit tedious!!!
I appreciate this is an issue that has been caused here and is nothing to do with the MDM. I asked for these jobs to be stopped as part of our last upgrade when I hit the same issue - unfortunatley the damage has already been done! Last time i stuck with it and managed to compile a list myself
Any help greatly appreciated