Collation Change for EV SQL Databases
I'm planning an upgrade of an EV 8 server to EV 9.0.4 and currently I have EV SQL databases with collation that does not match the collation of SQL master database. According to http://www.symantec.com/docs/TECH55063, all EV SQL databases should have a uniform collation (same as the SQL master DB) otherwise the upgrade to EV9 will fail.
I'm trying to figure out what are the exact steps to change the collation of EV DBs to match the SQL master collation. The articles provides 2 SQL queries in order to check collation status:
1) The first query checks if there any DBs with different collation (there are such DBs in my case)
2) the second query checks within each database to see if there is a mismatch with the columns of the database (db) for the EnterpriseVaultDirectory and each vault store database (this query does not report a problem in my case)
While the article provides a rather long procedure to change collation of problematic EV DB, it states that "Other solutions exists if only a mismatch exists from the first query where the collation can be changed at the database level itself, or install a new instance of SQL, create new databases with the proper collation and then restore the EV databases"
In the installation I'm checking, only the first query returns a mismatch so I wonder if I can only use the "collation change at database level" approach that the article mentions. If yes, does the "collation change at database level" approach includes only running the MSDN query referenced by the KB article without the extra steps (running parts of EV programmability scripts etc.) ?
Thank you very much in advance!