EV 2007 to 8.0 upgrade and the SQL Collation error
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?
Yip as log as you corrected
Yip as log as you corrected the relevant table and Deployment Scanner now says there are no issues, you good to go ;)
evdiscuss.net - bringing it all together
www.evtools.net - All your EV Tools
Most overboard indeed
The 293475 article is in my experience seriously overkill, and may even introduce new (and much more dire) issues if done improperly.
In most cases, opening the offending tables in design mode and changing their collations to db_default (or a specific one, if you really want to be on the safe side) is more than enough.
Eric, Do you remember what
Eric,
Do you remember what you did exactly? I have the collation error with the same table, MQUpgrade, in my test environment.
Nevermind. A few more clicks
Nevermind. A few more clicks into it and I found what I needed.
Would you like to reply?
Login or Register to post your comment.