I'm upgrading from Enterprise Vault 2007 to 8.0. When I run the deployment scanner I get a SQL Collation error on my VaultDirectory database.
I've seen http://seer.entsupport.symantec.com/docs/293475.htm as the method for fixing this. However, I think that the method outlined in that article is a little overboard consider what's actually wrong with my specific database. I have a single field in a single table with the incorrect collation. It's EnterpriseVaultDirectory. MQUpgrade.AgentType. First of all, the table is empty, the field AgentType has a custom collation, everything else has the default. I know how to change the collation for this field. I do it and run the Deployment Scanner and all it well. My concern is that I'm missing something. Can it really be that easy?